Dynamic Range
Hi All,
I have a data table which starts from A5001 to A50674. This data will
expand by adding new rows and columns.
How can I name this data.
Also I would like to create separate names for each column that is
added.
I tried using =OFFSET($A$5001,0,0,COUNTA($A:$A),1), but it does not
recognize the data.
Can someone help me.
Thanks
vishnu
|