I have an existing pivot table that takes raw data and moves it into a existing formated workbook. This pivot was created by an unknown person. The ability to be able from year to year transpose new raw data to a new workbook would be a very helpful tool. Anyone able to look at this file or able to help would be appreciated.