Hello everyone,
I was wondering if you could help me. I wanted a VBA code that can help me with the following.
- Copy a a pivot table (I have multiple pivot tables on the 1 worksheet so I want to be able to select which one).
- Paste this to a selected workbook called 'Data' worksheet 'Sheet1' on my C: drive. (This has to be paste value as this is a CSV file).
If this is possible any help would be great.
Thanks.
Dominic.
I was wondering if you could help me. I wanted a VBA code that can help me with the following.
- Copy a a pivot table (I have multiple pivot tables on the 1 worksheet so I want to be able to select which one).
- Paste this to a selected workbook called 'Data' worksheet 'Sheet1' on my C: drive. (This has to be paste value as this is a CSV file).
If this is possible any help would be great.
Thanks.
Dominic.