Käynnissä

Need Excel EXPERT

I get data weekly that I need to reformat and have computations run on. The file "raw data.xls" is how I get the data. The file "final results.xls" is how the end result should be.

Formatting and computations that need to be done:

1) Sort by K (WC Code on final results)

2) Sort by A (Company on final results)

3) Compare line by line the values of A AND K

4) If multiple lines have the same A AND K values then combine to a single line and sum the values of G, H, I and J

5) EXAMPLE NOTE: raw data has 7 lines and final results has 5 lines. Lines 4 and 5 have been combined and summed. Lines 6 and 7 have been combined and summed.

6) Add Headers

7) Bold and underline headers

Thanks

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

Thank you

Taidot: Excel

Näytä lisää: need excel expert, xls excel expert, reformat data, file excel expert, combined result, excel expert xls, montreal microsoft excel expert, contribute excel expertise, ofline data entry, optimize excel vba, sort excel, single line, need a excel expert, Excel Formatting, excel expert, excel 7, combine excel, multiple excel, underline, raw excel data, excel combine, excel reformat data, xls excel data, end expert, file excel compare

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

Projektin tunnus: #445582

Myönnetty käyttäjälle:

northwolves

Hi,sir As a top expert of excel,I'm looking forward to working with you,see PMB please.

30 $ USD 0 päivässä
(41 arvostelua)
4.9

28 freelanceria on tarjonnut keskimäärin 43 $ tähän työhön

jkrish

Please refer PM for details.

30 $ USD 1 päivässä
(52 arvostelua)
6.0
MAnkita

Hello,Please refer your [url removed, login to view] you.

70 $ USD 1 päivässä
(47 arvostelua)
5.7
best4best

I am an Excel expert. Please see PMB.

30 $ USD 0 päivässä
(79 arvostelua)
5.3
lucky2gaf

Hi, please check my PM for details, thanks.

50 $ USD 1 päivässä
(48 arvostelua)
5.4
techservice

Please check PM

30 $ USD 1 päivässä
(34 arvostelua)
5.2
pyazlm

You may check PMB for demo.

30 $ USD 1 päivässä
(30 arvostelua)
4.4
mahfuzmurshed

Please see PM.

30 $ USD 0 päivässä
(46 arvostelua)
4.1
SergeyPlus

Hello. Look PM please. Sergey S.

30 $ USD 1 päivässä
(10 arvostelua)
4.0
nmppatel

I have very good experience with Excel VBA. I have done many projects in Excel Skill of GAF. I will complete this project in few hours.

30 $ USD 0 päivässä
(9 arvostelua)
3.7
sujiumesh

please check the pm

30 $ USD 1 päivässä
(8 arvostelua)
3.5
TechnoSGIT

Hi, Please check my PM for details!!! Regards, Techno

40 $ USD 2 päivässä
(8 arvostelua)
3.5
skgtechnologies

Dear Sir, We are excel expert and our rates are only 40$ per week. thanks Sachin Gupta

40 $ USD 7 päivässä
(3 arvostelua)
2.7
supportkumar

Hai please check PMP

50 $ USD 1 päivässä
(4 arvostelua)
2.6
refractocd

This can certainly be done using Excel VBA. I am ready to start IMMEDIATELY. Please refer to PM.

50 $ USD 2 päivässä
(3 arvostelua)
2.5
rpdammu

Dear sir, Please check the PM Sincerely Rajendra

30 $ USD 1 päivässä
(5 arvostelua)
2.2
ExtraNet

Solution: Executable that can batch convert many excel files at the same time. You just have to select the files you want converted. See PM for details.

100 $ USD 3 päivässä
(3 arvostelua)
1.9
alok007patel

*Hello!Lets start* Check your PMB please,Thanks!

30 $ USD 0 päivässä
(1 arvostelu)
1.0
vindhyavart

Please have a look at your PMB. Thanks.

70 $ USD 1 päivässä
(0 arvostelua)
0.0
aniss55

Please see pmb.

30 $ USD 1 päivässä
(0 arvostelua)
0.0
doonsoftwares

I have seen both the files and ready to give the solutions as per detail. Thanks

40 $ USD 0 päivässä
(0 arvostelua)
0.0