Selecting a date range from drop down box

[loriandrick]

I want to be able to select a certain date range from a drop down box and when selected, only that weeks data is showing on the sheet. This is where i can enter hours for my shop. At this moment i have a sheet for each week of the year on the bottom of the workbook. I currently have about 60 sheets on the bottom. and going on and on and on.

 

[vconfused]

Sounds like an Access subform

Would having a drop-down box on the first page, that when selecting a date from, it takes you to that sheet, then having a link at the top of every sheet take you back to the first sheet work?

 

[loriandrick]

that sounds like the idea that I want to do. Is it possible that when i enter the data on the page that pops up, it will save the info. And is it possible to have a link on the top to bring me back to the main screen. It is sounding more like I have to use access

 

[daniels012]

If you have them all on separate pages, why not right mouse click any sheet tab... then select all sheets... then goto edit... find... type in the date.

NOte: You must have some kind of data in all sheets for this to work.

Hope this Helps,
Michael