Dropdown Lists changing data in other cells

[phooda]

Hello to all. I wanted to ask anyone to help me.

I have tried to make it by my self and i didnt make it. So please help me if you can.

I need this.

I want to have drop down menu with 50+ items, and i want to change values for few cells every time when change menu item. And thoose values that will be changed are in some table.

I hope you understand. If no, just say it i will try to explain better. Sorry on my english.

Very best regards Milos

[GreenDR]

you can use the below code to name all the cells containing values in the table,
and use the indirect function to point to the specific range.


Sub name_a_range()
Dim x As Integer, i As Integer
x = Cells(5, 11).End(xlDown).Row
For i = 5 To x
ActiveWorkbook.Names.Add Name:=Cells(i, 11).Value & "_Wheels", RefersToR1C1:="=Sheet1!R" & i & "C12"
ActiveWorkbook.Names.Add Name:=Cells(i, 11).Value & "_Doors", RefersToR1C1:="=Sheet1!R" & i & "C13"
Next
End Sub

I have also attached an excel file with the macro and demo for your reference

[phooda]

Beautiful :) It is just i want. Thank you and sorry because my slow reply!

Kind regards Milos

[phooda]

I have a problem. What ever i change, it does not work.

[Aussiebear]

Then you need to post the workbook ( or similar layout) to the forum, outlining the issue you have in what you were doing at the time and what you expected to happen. To do this please click on Go Advanced, scroll down to Manage Attachments and follow the prompts from there.