Calling all Forum Gurus and anyone that can provide some ideas...

I have attached a workbook similar to the ones I am working with and trying to get some Macros created. I am trying to create a macro that will include formatting the worksheet and create a pivot table with a calculated field. I have the following macro that worked on a previous workbook, and when I copied from that workbook to the new workbook, I get an error.

The code I have been using for this macro is....

Please Login or Register  to view this content.
The error I get reads...
An Error occurred: The PivotTable Field name is not valid. To create a PivotTable Report, you must use data that is organized as a list with labeled columns. If you are changing the name of a PivotTable field, you must type a new name for the field.

The headers on the worksheet are labeled the same as in the code. I have tried numerous name changes but I am apparently missing something because it keeps giving me this error.

I also want to be able to create a code that will highlight duplicate specific to the data in column A.

For Example:
In A2:A6, I have the Item number, MC75 MET DEVICE (NS) with the serial numbers received in column B and when we ship back to the customer, the serial shipped goes in column C(probably not in same order as in Column B). The range can vary from day to day for the quantity of devices that get received from the customer(One day can receive 1 device and then the next day can receive 10). Then I need the next Item number set for duplicates the same way and this to happen for each Item or group of Identical items on the worksheet.

I have been doing this manually through conditional formatting but would REALLY love if I could do this with a Macro.


Any help or direction would be GREATLY appreciated!!!!



Thanks!