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!
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!