Pivot Table by Macro?
 

I am trying to record a macro that will create a pivot table within a
workbook and receiving an error.

Is this something that will have to be done manually everytime I create this
file or am I just missing something?

Thanks in advance.

Roger