Macro to run differently depending on text in drop down cell.

[Luke1690]

Hi,

i Think this should be an easy one for you guys.

i have made a macro that copies data from (workbook1) to a specific workbook, (Workbook A) related to that area. To activate the macro i have used a button.

i have had to duplicate workbook1 several times and change the code so the data can copy to other specific workbooks A,B,C,D related to different zones, when a button is clicked.

What i would like is one copy of (workbook1) but when the name of a workbook is chosen from a dropdown list for example (workbookA) the data is copied to that workbook, after the button click. (Only one button please)

*drop down can be any cell*

i cant give you an example gdpr....

Thanks Guys i hope that makes sense...... basically determine how the code is run/or what code is run by text from cell. using only one button!

 

[6StringJazzer]

Glad to help. Let me know if you have trouble after you actually implement the change.