New to Macros, can't get them working!

[hmiskimmin]

Hi there, I created a macro that runs well on one set of data but will not work when I try to run it in another workbook with a different dataset.

It flags up an error message saying 'run time error 1004 pivot table field name not valid'

My code is as follows:

Please Login or Register  to view this content.

[davesexcel]

First thing I see is you have two different names for the Table.