Hi All,

I am new to the forum. My job profile demands me to creates Charts and Graphs and paste those to PPT this is repetitive task every month . If any one can help me with some VBA automation to do this task this will save lot of my OT hours (nearly 30 to 40 hours per month).

Here is my case details.

Case Details:
1.Every month i get data dump
2. I have nearly 15 standard column name(headers)
3. I have to match these 15 standard column from data dump and pick only those.
4. Once Raw data is ready i have to paste those data to existing Product templates(excel template) and refresh all the chars and graphs.
5. Once all the data is refreshed i have to filter product wise pivot and Charts in (excel template) Once Pivot and chart is ready for product 1 i have to copy paste the Pivots tables and charts
to PPT while copy pasting i have maintain same alignment every month.

Eg: >If i select Product 1 all my charts and pivots will show data only related to product1 and i have to prepare the PPT with name as Product1, Normally one PPT file includes nearly
30sides which needs to be cop pasted from product1 excel template.
>Once the product 1 PPT is ready go back to excel template change it to Product 2 now all my charts and pivots will show data only related to product2.

6.Like this i have to do it for State wise products, Regions wise etc individually.

Summary:
If any one can help me with VBA codes / template which will automatically matches the headers from my standard headers list with data dump and paste those to my template.
and we should have User form on the main page and if we select the Product , region in the user form and run the the code system should automatically change the pivots and graphs based on the User form selection and export those charts and graphs as PPT with file name (PPT for Product1).


Hope some one may be able to help me on this. My Advance Thanks as this will save my lot of time.

Regards