Selecting Item from a Dropdown - Code Needed

[RhyGuy]

Good Day All,

I am currently writing a macro to copy and paste data from one workbook to another. The copied data is always from the same sheet, with exactly the same format. But the data in that sheet changes depending on the variable I select from a dropdown list that resides on a separate sheet. The challenge I am having, is when selecting the dropdown list, the macro does not know I am doing that and will not update the worksheet based upon the selection I made in the dropdown list.

For example, in the dropdown list I have Moncton, Montreal and Toronto. The active item in the dropdown list is Moncton, but when I record the macro to select the list and change it to Toronto, this does not happen and the worksheet with the data still refers to Moncton data. When I review the code, all it appears to be doing is selecting that cell, but no activity is being created for the dropdown function (Range("F6").Select). Is there a way to modify the code for it to actually access the dropdown and select the item I want?

Thanks in Advance

Rhy

 

[SiddersAtCHEP]

Maybe I don't quite understand the question, but if you put code in the Change activity, doesn't that work?

Brgds