PDA

View Full Version : Excel Formula's



Chris Hoover
02-08-2001, 12:33 PM
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?

Barry Wilson
02-22-2001, 10:57 AM
Start with this web page http://www.cpearson.com/excel.htm
links from here also goto Excel Guru's


http://www.cpearson.com/excel.htm

Barry Wilson
02-22-2001, 10:59 AM
Start with this web page http://www.cpearson.com/excel.htm
links from here also goto other Excel Guru's


http://www.cpearson.com/excel.htm