Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Varible reference to worksheet name
I receive a new generation file each day about 40m records and 150 columns -
give or take both ways depending on the day. Columns can and do come and go but- for the most part I am insensitive to this movement other than location/order changing. Each day I save the new generation file as a worksheet in a book where I maintain historical data. Each day's worksheet receives the corresponding name of the file generation; 100.01, 100.02, 100.03, 101.01, 102.03 you get the idea. My wish is to integrate a data sheet I have which feeds a large model with the historical worksheets where I would have the ability to qry the same handful of columns form within any historical worksheets by putting the name of the worksheet/file generation desired in a single cell (i.e. 103.02 for example). My difficulty is that due to the large number of records it is impractical for me to to use some of the solutions I found here as they would not allow cell and column references to be copied down and across. Also, variability in the columns is presenting a challence but on the bright side field/colunb names do not change I tend to believe I might be able to achieve this with indirect or offset functions but I have little experience with these - otherwise i'm rather proficient. Thanks in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
varible calculation | New Users to Excel | |||
Loop through varible list of sheets | Excel Discussion (Misc queries) | |||
varible table not | Excel Worksheet Functions | |||
varible table | Excel Worksheet Functions | |||
how do i set up repeating titles with varible data | New Users to Excel |