That's working but I want the new tab to be at the front - pushing older tabs to right. I tried changing the copy line from After to Before, but that only works once. I've attached a sample workbook; green tabs would be created by the macro (produced manually in this case). Yellow tabs indicate starting point for the file. Should look like this:
time tracker.PNG
Also, w/in the work book module1 - test sub is some of the code that should be used to append a pivot table to the new sheet.
HTH
p.s., cross posted on ExcelForum, answers.microsoft and MrExcel ... little traction there.
Thanks!
Bookmarks