Need a macro that opens all the workbooks in the c: drive file paths c:\documents and setting\test
One by one and copies the data in worksheet "cm" and and pastes the data onto a master workbook same file path called "Master Template" and into worksheet "cm1". So the data is stacked one under Neath the other...
Workbooks in c: drive file paths c:\documents and setting\test are:-
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.