Need a macro that modifies test [url removed, login to view]
Check for duplicate on Company (Column B) and Job title (Column F)
For Unique companies, sum Total Wages (Column P) into Column Q
Move Sum back to Column P
Delete Duplicate Entries
Separate States with 4 Blank Rows
Sum the total (Column P) for Each State
Delete Column D, E, I, J, K, L, M, N, O
I have attached how the final result should look.
Need a macro created. No data entry people please.