My second VBA question
I want to do the following:
Using just one of the filters on a spreadsheet pivot table, cycle through each of the selections and copy and paste it to a new workbook and save each as a CSV with the name of a cell (H1 to be precise).
I would then have 25 csv file extracts in a set directory and would be very happy!
Now what I have is the following obtained by cobbling code together from recording basic steps and the internet, I have the following code, but as you can see it doesn't work, and I don't have enough knowledge to problem solve it.
Thank you in advance
Bookmarks