Excel Excel Formula Creation Assistance

Joined
Feb 5, 2009
Messages
1
Reaction score
0
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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top