I am making mistake and I can’t understand what I am doing wrong.
Dynamic named ranges is what I was busy with in Excel 2003.
This is practical problem:
In worksheet `A` I have data in column O.
I need last value (and last value will change) from column O to display in another worksheet (`B`) in cell A634.
This is what I did in for column O in `A`:
Insert>Name>Define
I’ve typed “range” in Name in workbook, while I’ve typed into Refers to the following:
=OFFSET($O$4,0,0,COUNTA($O$4:$O610),1)
As of now last value in O column is in O599, with column work area being extended down to O610 and before O610 is reached I will be expanding column by adding extra 10 rows. (Insert>Row)
If this is correct and if this means that range in O will extend as I add more rows with new data – What I need to type in cell A634 in another workbook in order to have last value from O column displayed? (after each addition of new data and rows and calculations in O)
Thank you in advance.