I hope you can help me with a problem.
For background information what I am doing is that I have a pivot table in Excel that shows all orders placed for all customers, each customer is listed in the "CusRegDirector" column field so all I need to do is simpy untick "showall" and tick the customer I wish to see, I then want to copy and paste the data that is returned to a new excel file and save the new file.
The problem is I wish to repeat the above process for each customer in the list, again fairly simple, but the customer list will always change so I can not simply create a macro with a predefined pivot item list.
What I need is a way to tell the script to go through each item one by one from start to finish and perform the "copy/newfile/paste/save as" process for each item.
Im sure the above should just be simple, however im not a programmer so its not so simple to me.
I have created a macro that can do all the copying/pasting and create a new file etc, its simply the Pivot Items list I need to figure out.
I can provide the code I have and a screen shot or two of the excel file.
Can anyone help?
For background information what I am doing is that I have a pivot table in Excel that shows all orders placed for all customers, each customer is listed in the "CusRegDirector" column field so all I need to do is simpy untick "showall" and tick the customer I wish to see, I then want to copy and paste the data that is returned to a new excel file and save the new file.
The problem is I wish to repeat the above process for each customer in the list, again fairly simple, but the customer list will always change so I can not simply create a macro with a predefined pivot item list.
What I need is a way to tell the script to go through each item one by one from start to finish and perform the "copy/newfile/paste/save as" process for each item.
Im sure the above should just be simple, however im not a programmer so its not so simple to me.
I have created a macro that can do all the copying/pasting and create a new file etc, its simply the Pivot Items list I need to figure out.
I can provide the code I have and a screen shot or two of the excel file.
Can anyone help?