Pivot table is inserting a filter to the right of the pivot table

[taylorsm]

I have a macro that takes a timeclock report and breaks it down into managers and if someone was late or not.

It is taking the managers name on the first pivot table and instead of inserting it at the top of "A:B" it is putting it in "D:E".

I'm sure i'm screwing something simple up but I can't figure it out. There are four macros. This one is the second in line, if I stop the code and try to manually insert, it does it wrong too. One workbook is the raw, the other is what it looks like and you can see in D:E how it is weird.

Please Login or Register  to view this content.