New Excel Forum

This forum has been moved to TeachExcel.com

Ask all future questions in the New Excel Forum.

ExcelKey

macro to select from a drop down list on multiple sheets

Macros, VBA, Excel Automation, etc.

macro to select from a drop down list on multiple sheets

Postby maxwellfd » Thu May 19, 2016 8:55 am

I have an excel workbook that has about 7 sheets. Each sheet has its own drop down list (with names of employees) which then populates the graph associated with that sheet. I want to create a macro that allows the user to select their name from the drop down list on sheet 1 and then click a macro button so that all the other sheets are then updated with their selection.

Any help is greatly appreciated! I am not too familiar with macros.
  • 0

maxwellfd
Rookie
 
Posts: 1
Joined: May 19, 2016
Reputation: 0
Excel Version: 2010

Re: macro to select from a drop down list on multiple sheets

Postby charles » Sat Jul 09, 2016 1:49 pm

Hi,

It would help if you can post a workbook with a sample of your data.

Charles
  • 0

There are other ways too do this but...

Be kind let us know if you posted somewhere else!



Charles
charles
Excel Badass
 
Posts: 632
Joined: Dec 10, 2011
Location: Mississippi
Reputation: 1
Excel Version: Excel 2003, 2007 and Mac 2011


Return to Macros and VBA Questions

Who is online

Users browsing this forum: No registered users and 36 guests