Already selected values from DropDown list dynamically updating on multiple sheets

Hello,
after googling for 2 days and trying to figure it out myself and failing, i came here to ask for some help.

I have mulitple sheets with ranges in it containing values selected from a drop down list.
Worksheets("Part Database").Range("C3:C10") <-range contains values selected from DropDownList
Worksheets("APM2").Range("D5:D11") <-range contains values selected from DropDownList
Worksheets("APM3").Range("K8:K15") <-range contains values selected from DropDownList
Worksheets("Input").Range("I2:I7") <- this sheet range contains the DropDown list source, I1 is the header of the list, the code also pasted on this sheet.

Please Login or Register  to view this content.

The following code updates the ALREADY selected values from the DropDown on the Part Database sheet, if i change the source of the DropDownList on sheet "Input". It works just fine.

But i want to add more two more sheet range to the code to work:
Worksheets("APM2").Range("D5:D11")
Worksheets("APM3").Range("K8:K15")
The question is, how do i implement it to the code, so it not only updates the Part Database sheet C3:C10 range, but the two more ranges on APM2 and APM3 sheets?

Hi nyuffancs and welcome to the forum,

Without seeing an example file it is hard to understand your question. It sounds like you need to learn about Dynamic Named Ranges or Cascading Dropdown to do your problem.

http://www.ozgrid.com/Excel/DynamicRanges.htm
https://www.excelcampus.com/tables/d...nt-drop-lists/

If neither topic helps then add an example workbook:
Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Hi nyuffancs,

I'm sorry but your example file doesn't help me understand your problem. I see your code (which should be enclosed in code tags) but it doesn't help me much either. What are you trying to do? Why do you want all your ranges to be equal to what is selected on your first sheet? Are you simply trying to understand how to write code?

OK,

After a lot of head scratching to understand what you wanted, see if this works:

Please Login or Register  to view this content.