Need EXCEL EXPERT to Complete an Unfinished Macro

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 [url removed, login to view])

2) Sort by Column B (Address on [url removed, login to view])

3) Sort by Column C (City on [url removed, login to view])

4) Sort by Column E (Classification on [url removed, login to view])

5) Sort by Column K (WC Code on [url removed, login to view])

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: [url removed, login to view] has 7 lines and [url removed, login to view] 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

Taidot: Excel, Visual Basic

Näytä lisää: xls excel expert, works need excel, test excel expert, single match, reformat data, on line data entry test, looking for excel expert, looking for an excel expert, i need workers or company, i need data entry done today, how to be an expert on excel, how to be an excel expert, how excel works, file excel expert, excel test expert, excel macro how to, excel 0 to expert, data entry macro, data entry address test, combined result, address data entry test, how data entry works, company that need workers, company looking for workers, today need

Tietoa työnantajasta:
( 25 arvostelua ) Burbank, United States

Projektin tunnus: #522708

Myönnetty käyttäjälle:


Looking forward to working with you....

$40 USD 0 päivässä
(62 Arvostelua)

4 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön


VBA developer since 1997. Can do. Regards, Svet.

$55 USD 1 päivässä
(79 arvostelua)

Hi, please view my PM for details, thanks.

$80 USD 1 päivässä
(49 arvostelua)

Please see PMB

$50 USD 1 päivässä
(20 arvostelua)