I have a workbook that will consist of many sheets.
One sheet will contain multiple rows to type info
when I type the info, I would like the page to appear or the info displayed in the formula sheet. one of the formulas must have a date range.
example1:
BOX B2 you can type member's name.
---the formula will display the worksheet with the info (I know I can use the find tool located at the top of the screen)
example2:
Box B4 you type in date #1 (1 jan 00) and box B5 type in date #2
---the formula looks for sheets that have the date range in a specified box...
----(If I am looking for classes ending from 1 feb 00 - 15 feb 00, it will display all class rosters from the workbook.... NOTE: class rosters are saved on individual tabs/worksheets)
thanks!
I'm new to the forum, but I have searched around before and found lots of answers, so thanks!
One sheet will contain multiple rows to type info
when I type the info, I would like the page to appear or the info displayed in the formula sheet. one of the formulas must have a date range.
example1:
BOX B2 you can type member's name.
---the formula will display the worksheet with the info (I know I can use the find tool located at the top of the screen)
example2:
Box B4 you type in date #1 (1 jan 00) and box B5 type in date #2
---the formula looks for sheets that have the date range in a specified box...
----(If I am looking for classes ending from 1 feb 00 - 15 feb 00, it will display all class rosters from the workbook.... NOTE: class rosters are saved on individual tabs/worksheets)
thanks!
I'm new to the forum, but I have searched around before and found lots of answers, so thanks!