One way that I thought of is indexing the field list before creating the pivot table.. eg, from 1 to 144. then have a code iterating (maybe a do loop?) through it, for i =1, i = i +1 . something like that.Originally Posted by Bradley123
What do you think