I have a workbook with many work sheets. In worksheet "Job List" I have a macro that builds a dynamic list with the header data in C7:J7. There can be one data row up to several hundred data rows. So I need to be able to copy the source data dynamically to the last row of data. I need to create a pivot table from this data to worksheet "Calc" starting in A1 of that sheet. The row will be "Acct. Code"Also, and the columns will be "Total W/O Tax" and "Total Price". I need to turn ColumnGrand to False so it doesn't create the grand total. I recorded a macro to create the pivot table, however it doesn't work all the time, so I thought VBA would the best answer. I know a little about VBA and can usually work my way through, but his is a little over my head. The following screen prints show 1) The source data 2) what I need the pivot table to look like. Any help would be greatly appreciated.