Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Dynamic Ranges
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamic Ranges | Excel Worksheet Functions | |||
Dynamic Ranges | Excel Discussion (Misc queries) | |||
Dynamic Ranges with ADO | Excel Discussion (Misc queries) | |||
dynamic ranges | Excel Worksheet Functions | |||
Dynamic Formulas with Dynamic Ranges | Excel Worksheet Functions |