LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Drop Down box resizing on open Duncan UK New Users to Excel 0 November 24th 06 10:09 AM
Format drop down option won't open on selected cells Ron West Excel Discussion (Misc queries) 1 October 12th 06 09:36 PM
Theres no toolbars, no drop-down menus when I open Excel UA Setting up and Configuration of Excel 2 June 12th 06 12:25 PM
Open hidden sheets from a drop down list selection Ant Excel Discussion (Misc queries) 3 October 7th 05 10:01 AM
drop down box to open when selected Tammy Excel Worksheet Functions 4 December 31st 04 03:48 PM


All times are GMT +1. The time now is 03:39 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"