Posts by SomewhereNorth

Is there any way for a Tab to be named with the contents of a cell without coding?

Plain Vanilla,
SomewhereNorth

Thank you Seti and Jindon, Both work.

SomewhereNorth

Bingo.

I adjusted the COUNT function to look like this:

=OFFSET(B1,COUNT(B1:B52)-1,0)

It works perfectly.

Thanks a million.
SomewhereNorth

Please forgive my ignorance here.

I'm not sure how to do coding - I don't know if I have that capability. Is there any way to do it with a formula?

Thanks again,
SomewhereNorth

I'm trying to reference the bottom-most non-blank cell in a column (or a range of cells). Any ideas?

Picture this: 52 rows for 52 weeks. I enter data into the corresponding row once a week. I need to automatically reference the latest data entered into certain columns spanning the week's (row) information. I need to reference the lowest cell in a column that has data in it.

Thanks,
SomewhereNorth