updating sheet by choice from drop down menu

K

kal4000

I have a drop down menu with weeks to choose from in a sheet with some charts
& graphs. I want to update the charts & graphs with the info from the week
that is chosen in the drop down menu (from other sheets in the workbook).
Right now, I'm using dynamic names to update the charts and the drop down
menu just changes the week that is displayed. Should I use VLookup or
something else to accomplish this?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Drop Down choice needs to lead to another drop down menu 1
Drop-down menu and additional sheets 4
DROP DOWN LIST WHEN SPREAD SHEET OPENS 5
lost the drop down list (the validation still exist) 4
DROP DOWN MENUS with formulas 5
Drop Down List with Macro/Hyperlinks 4
How to make items in a drop down menu reference a number 2
Linking choices in drop down menu to have automatic answer... 3

Top