Project Detail

Description

I get data weekly that I need to reformat and have computations run on.

The file "before.xls" and "test data.xls" are how I get the data. The file "after.xls" is how the end result should be. I have included the un-finished macro (90% done) that works on the "before.xls" but NOT the "test data.xls" file.

Formatting and computations that need to be done:
1) Sort by Column A (Company on after.xls)
2) Sort by Column B (Address on after.xls)
3) Sort by Column C (City on after.xls)
4) Sort by Column E (Classification on after.xls)
5) Sort by Column K (WC Code on after.xls)
6) Compare line by line the values of A AND K
7) If multiple lines match on ALL 5 values then combine to a single line and sum the values of G, H, I and J
8) EXAMPLE NOTE: before.xls has 7 lines and after.xls has 5 lines. Lines 4 and 5 have been combined and summed. Lines 6 and 7 have been combined and summed.
9) Add Headers
10) Bold and underline headers

I am looking for a script or macro. I am NOT looking for manual data entry workers.

I need this done today if possible.

Thank you


Additional files submitted:
after.xls
before.xls
format.xls
test data.xls