Formula finding last cell in row containing data

AbbieW · Jul 10, 2007

I have a large workbook that I enter data into each month. On one worksheet
I need to copy only certain pieces of the current month's data. I know I
need a formula that finds the last cell that contains data in a row. I'm not
that good at this, so it's over my head. Can anyone help me?

T. Valko · Jul 10, 2007

See this:

http://xldynamic.com/source/xld.LastValue.html

AbbieW · Jul 10, 2007

Thank you so much. That was exactly what I needed. Why didn't I think of
Lookup? I really appreciate your help!
--
Abbie W.
Missouri Dept. of Corrections

T. Valko said:
See this:

http://xldynamic.com/source/xld.LastValue.html

T. Valko · Jul 11, 2007

You're welcome!

--
Biff
Microsoft Excel MVP

AbbieW said:
Thank you so much. That was exactly what I needed. Why didn't I think of
Lookup? I really appreciate your help!