Chris Hoover
02-08-2001, 11:33 AM
Ok, I need a webpage or something for help on dynamically creating formula's in MS Excel 2000. I want to input a date in one cell, and call information from another worksheet based on that date.
ie: In the main sheet, there's a cell with 02/02/00 (user input).
There's a few sheets named S020200.xls, S020300.xls, S020400.xls, etc.
I want to dynamically call data from whichever sheet the user inputs for the date in the main sheet.
This make any sense at all?
ie: In the main sheet, there's a cell with 02/02/00 (user input).
There's a few sheets named S020200.xls, S020300.xls, S020400.xls, etc.
I want to dynamically call data from whichever sheet the user inputs for the date in the main sheet.
This make any sense at all?