Hello,
I need help creating a VBA Pivot table on any sheet containing the word "List". They are always named "List1" or "List2" but there can be a different number of these sheets each time.
The Pivot should be 10 lines under the last row of data in column A, for each of the List sheets.
The data is always in columns A-Q and has headers in row 1. The number of rows always varies.
The table is always the same Date in rows, Province in columns, and count of province in values.
THANK YOU for any and all help. And let me know if there is any clarification needed.
I need help creating a VBA Pivot table on any sheet containing the word "List". They are always named "List1" or "List2" but there can be a different number of these sheets each time.
The Pivot should be 10 lines under the last row of data in column A, for each of the List sheets.
The data is always in columns A-Q and has headers in row 1. The number of rows always varies.
The table is always the same Date in rows, Province in columns, and count of province in values.
THANK YOU for any and all help. And let me know if there is any clarification needed.