Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
J-Rad
 
Posts: n/a
Default drop down menu containing worksheet names

hi all,

i'd love it if someone could show off their excel prowess on this one.

what i'm trying to do is have a workbook with multiple "common"
worksheets and one main worksheet. on the main worksheet i want to
have a drop-down menu where you select which common worksheet you want
to pull data from to populate the main worksheet.

the common worksheets will always be the exact same structure and will
contain a weeks worth of data. every week i want to "move and copy" a
common worksheet so that i have one worksheet for evey week. i don't
want to have to make a million worksheets at the inception of the
workbook.

what i think will be the tricky part is having the drop-down menu
automatically update so at any point in time i would be able to select
any common worksheet available.

ready to learn...

-jarrad

  #2   Report Post  
Gary Brown
 
Posts: n/a
Default

Sounds like you should be looking at the INDIRECT function in HELP.
HTH,
Gary Brown

"J-Rad" wrote in message
ups.com...
hi all,

i'd love it if someone could show off their excel prowess on this one.

what i'm trying to do is have a workbook with multiple "common"
worksheets and one main worksheet. on the main worksheet i want to
have a drop-down menu where you select which common worksheet you want
to pull data from to populate the main worksheet.

the common worksheets will always be the exact same structure and will
contain a weeks worth of data. every week i want to "move and copy" a
common worksheet so that i have one worksheet for evey week. i don't
want to have to make a million worksheets at the inception of the
workbook.

what i think will be the tricky part is having the drop-down menu
automatically update so at any point in time i would be able to select
any common worksheet available.

ready to learn...

-jarrad



  #3   Report Post  
Bob Phillips
 
Posts: n/a
Default

Add a combobox from the controls toolbar, and add this code to it

Private Sub ComboBox1_DropButtonClick()
Dim sh
With Me.ComboBox1
.Clear
For Each sh In ThisWorkbook.Sheets
.AddItem sh.Name
Next sh
End With
End Sub

You can use its click event and do your stuff there.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Gary Brown" wrote in message
...
Sounds like you should be looking at the INDIRECT function in HELP.
HTH,
Gary Brown

"J-Rad" wrote in message
ups.com...
hi all,

i'd love it if someone could show off their excel prowess on this one.

what i'm trying to do is have a workbook with multiple "common"
worksheets and one main worksheet. on the main worksheet i want to
have a drop-down menu where you select which common worksheet you want
to pull data from to populate the main worksheet.

the common worksheets will always be the exact same structure and will
contain a weeks worth of data. every week i want to "move and copy" a
common worksheet so that i have one worksheet for evey week. i don't
want to have to make a million worksheets at the inception of the
workbook.

what i think will be the tricky part is having the drop-down menu
automatically update so at any point in time i would be able to select
any common worksheet available.

ready to learn...

-jarrad





  #4   Report Post  
J-Rad
 
Posts: n/a
Default

Bob-

thanks so much...that's exactly what i needed.

my project is going to be perfect now.

thanks a million

-jarrad

Bob Phillips wrote:
Add a combobox from the controls toolbar, and add this code to it

Private Sub ComboBox1_DropButtonClick()
Dim sh
With Me.ComboBox1
.Clear
For Each sh In ThisWorkbook.Sheets
.AddItem sh.Name
Next sh
End With
End Sub

You can use its click event and do your stuff there.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Gary Brown" wrote in message
...
Sounds like you should be looking at the INDIRECT function in HELP.
HTH,
Gary Brown

"J-Rad" wrote in message
ups.com...
hi all,

i'd love it if someone could show off their excel prowess on this

one.

what i'm trying to do is have a workbook with multiple "common"
worksheets and one main worksheet. on the main worksheet i want

to
have a drop-down menu where you select which common worksheet you

want
to pull data from to populate the main worksheet.

the common worksheets will always be the exact same structure and

will
contain a weeks worth of data. every week i want to "move and

copy" a
common worksheet so that i have one worksheet for evey week. i

don't
want to have to make a million worksheets at the inception of the
workbook.

what i think will be the tricky part is having the drop-down menu
automatically update so at any point in time i would be able to

select
any common worksheet available.

ready to learn...

-jarrad




Reply
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
Dynamic Worksheet Names JClub Excel Worksheet Functions 1 January 10th 05 09:55 PM
Applying a formula to a drop menu choice Andrew Hill Excel Discussion (Misc queries) 1 January 4th 05 12:05 PM
How do I set up a drop down menu for a validation list? UisNike Excel Worksheet Functions 2 December 29th 04 08:13 PM
link drop down menu to info in worksheet bob New Users to Excel 2 December 14th 04 11:09 PM
How do I Delete a file from the drop down file menu? Sander Excel Worksheet Functions 2 November 6th 04 06:05 PM


All times are GMT +1. The time now is 09:35 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"