updating sheet by choice from drop down menu

  • Thread starter Thread starter kal4000
  • Start date Start date
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?
 
Back
Top