the solution can better be provided if you put a sample of your file.

Eric Wrote:
Hi,
I've got a workbook with a number of worksheet tabs
labeled "May 2006", "June 2006", "July 2006", etc
in another tab called "Summary" I want to let the user enter a date and
when
he does the date will be used to figure out witch tab and from that
tab
display a block of data. (even better would be a dynamically updated
drop
down box with a list of tabs that the user could choose from, but not
listing the first 3 worksheet tabs in the workbook as they are
different
type.)
ie in "Summary" tab
Enter Date: <user enters date here, say "June 2006"
then when he presses enter, the formula goes and grabs block A4:L40
from the "June 2006" tab and displays it in Summary tab.
This way i can have lots of "Month tabs" and you can view any month
in the Summary sheet just by entering (or selecting) the desired date.
Note
that each "Month sheet" also has a cell with that months date in it so
that
could also be used to find the correct sheet.
How can i do this?
Thanks
Eric


--
starguy
------------------------------------------------------------------------
starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434
View this thread: http://www.excelforum.com/showthread...hreadid=563955