wrote in message
...
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


Try it like this...

Include your sheet name:

=SheetName!$A$5001:INDEX(SheetName!$A$5001:$A$6553 6,COUNTA(SheetName!$A$5001:$A$65536))


--
Biff
Microsoft Excel MVP