Hi all,
Very new to VBA, would appreciate any help/feedback.
I have 3 sheets under one workbook all under the same formatted heading in source workbook (4. Summer 17 Master Chart). The sheets are named RETAIL, OUTLET, SPECIAL SALES.
I want to add a button in the sheet "COSTING LP" in my target workbook (NEW LINE PLAN TEMP). The button would copy all the data under the headings from all 3 source sheets and paste them all as values in the "DATA" tab in the target workbook so I can have one consolidated chart. The DATA tab has the same formatted headings as the source sheets. What is the best way to go about this?
Thanks!
Very new to VBA, would appreciate any help/feedback.
I have 3 sheets under one workbook all under the same formatted heading in source workbook (4. Summer 17 Master Chart). The sheets are named RETAIL, OUTLET, SPECIAL SALES.
I want to add a button in the sheet "COSTING LP" in my target workbook (NEW LINE PLAN TEMP). The button would copy all the data under the headings from all 3 source sheets and paste them all as values in the "DATA" tab in the target workbook so I can have one consolidated chart. The DATA tab has the same formatted headings as the source sheets. What is the best way to go about this?
Thanks!