View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Lauren Giles Lauren Giles is offline
external usenet poster
 
Posts: 70
Default Drop down to open a different spreadsheet?

Okay, so I've got this workbook. It's a fairly complex budget workbook, and
one (well, twelve, actually) of the sheets are "daily spending," and have
every day in the month outlining what was bought each day, for how much, etc.

My question is: is it possible to put in a drop-down list that will allow
the different month's daily spending spreadsheet to show on the current page?
I want the drop-down to have the options for "Current Month," and
January-December. I'm sorry if I'm explaining this badly...

So, I want one worksheet to be visible and it will always have one of the
months open, but if you choose another month, it will switch to that month
and display that one. How can I do this?

Thank you SO much for any help.