Trying to build a code into a command button that would take every row in the pivot table and create 12 new rows in a table in a separate sheet. Columns A-C would be repeated on each new row; D5-O5 would be transposed as EOM onto the 12 new rows along with their correlating amounts in rows 7 to variable. There are four different sheets that would be following the code before completing the command. Any thoughts where to start?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
VBA Copy multiple PivotTables onto one table
- Thread starter rach_oh
- Start date
Similar threads
- Question
