Compare 2 Excel Worksheets & Show Items Added, Removed & Modified

Hi watersev, hope you are fine! Your macro has earned me lot of appreciations here at my work but the real credit goes to you mate

I have now a requirement to add some more information & do some formatting to our spreadsheet & would again need your help. I hope you can help me with this. I do not want to flood you with my requirements & therefore would like to bring this to you one at a time. Below is my specific requirement:

I have added a tab named "PO Spend Report (Raw)" with sample data (Ex: Part Number, Quantity, PO Spend, etc.) to our spreadsheet (attached here). Typically, we will run a similar report and paste it in this tab.

This data will probably have duplicate entries (Part Numbers) as seen in the sample table (Ex: Mouse & Speaker are ordered on different dates).

Requirement: A pivot has to be applied on this table to show unique entries in a new tab. This new tab should be created after user clicks on "Run" button & be named as "PO Spend Report (Formatted)". The data in this new tab should be as shown in the sheet.

Note: In the new tab, the column headers have been updated. We need it to be in this format.


I hope I have explained the requirement clearly. Please feel free to revert incase you are not clear on something or need more information.

Thanks once again and hoping you can help me with this. Once this is complete, I will post my next requirement.

Thanks!