VBA to adjust format for Pivot table use or database import.

Hello,

(View the example)
Do any of you know the VBA code to adjust the format in sheet1 to the proper format in sheet2. I need to adjust the format for pivot table use or database import. Thanks.

adjustFormat.xlsx

Thanks.

Try this:

Please Login or Register  to view this content.

Thanks. It worked perfect.