Hi guys
I have created a pivot table and i would like to know how to create a macro to loop through each row at a time.
For example, only auto select each name at a time under the 'Name' heading in the pivot table.
Please see attached doc.
I hope the example is clear enough for you to understand.
Thanks in advance.
John
Bookmarks