Hello,

I am working with a spreadsheet with a many rows and columns (it is an
export from a database). Overtime the number of rows will grow. I would
like to create a dynamic range. To do this I highlighted the page and
defined a name like this:

=OFFSET(Export!$A$1,0,0,COUNTA(Export!$A:$A),1).

Is this correct? Or should I only highlight the first column?

My goal is ultimately to use the data from this page (which will be
refreshed periodically) on another worksheet that will include VLOOKUP and
some simple calculations.

To begin I need the first column from the Export Page on the next worksheet.
How do I do this. My thought was to reference the Export Cells. But not
sure how to make the column grow without referencing again.

Please advise.