Excel Data Validation List Macro or Formula Help
Hello,
Please see attached sample. Im hoping someone can recommend either a formula or a macro that will do the following:
Once a position is selected from the data validation drop down list in sheet1, the person/s name and salary will populate starting in columns B15 and C15. For example, if Waterboy is selected, both John Doe and Brad Pitt's name and salary would appear. If quarterback is selected, the names would clear and only Tom Cruise's name and salary would appear.
Thank you for any assistance in advance!
EE-Sample.xlsx
Please see attached sample. Im hoping someone can recommend either a formula or a macro that will do the following:
Once a position is selected from the data validation drop down list in sheet1, the person/s name and salary will populate starting in columns B15 and C15. For example, if Waterboy is selected, both John Doe and Brad Pitt's name and salary would appear. If quarterback is selected, the names would clear and only Tom Cruise's name and salary would appear.
Thank you for any assistance in advance!
EE-Sample.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Sorry I mean in Column P. Not E.
cel is where the position is
cel.Offset(, 6) means 6 cells to the right of cel
cel.Offset(, 12) means 12 cells to the right of cel
You can change the value of 6 or 12 by counting the columns to the right of the position cell
cel.Offset(, 6) means 6 cells to the right of cel
cel.Offset(, 12) means 12 cells to the right of cel
You can change the value of 6 or 12 by counting the columns to the right of the position cell
ASKER
Thank you!!!
ASKER