In Progress


Each day we get reports sent to us for orders that have been placed from the web. These reports that are sent we cannot modify them, so we need to find a way to change them up a bit once we download them. I have attached an example of the report we get in its exact form. We take this spreadsheet and map it into our database along with our shipping programs. Our database needs all of these customers in one file but our shipping programs only need the info for the customers that select their shipping service.

So the first step for us is to download the report that I have attached, delete rows 1-7, and columns “W” & “AU” need to be formatted, special, zip code. Then we map this into our database.

Once this is complete we then filter column “AZ” and delete the rows that show DHL, then upload this into UPS world ship.

Once this is complete we filter column “AZ” and then delete the rows that show UPS, then upload into DHL easy ship.

As you can see this is a lot of steps and take a considerable amount of time being this is done 4 times daily.

Here is what I would like done.

1. Somehow split the original file we get and split it into 3 different files. I would like these files to somehow go into a different folder on the same computer. These 3 different folders would be for our database, UPS and DHL. If the one spreadsheet we download could be autoformatted to somehow take the data we need from the original sheet and then throw these sheets into the correct folders would be the most ideal.

2. The first sheet should be for our database and all that needs done for this file would be.

a. Delete rows 1-7

b. Format columns “W” & “AU” special, zip codes. (This needs to be done because if a zip starts with 0 it will not display the 0)

3. The second sheet should be for UPS and what needs done for this file is

a. Delete rows 1-7

b. Format columns “W” & “AU” special, zip codes

c. Row “AZ” should only have UPS orders and the DHL orders should not be part of this sheet.

4. The 3rd sheet will be the same as above just DHL instead of UPS.

If possible we would like this done ASAP.

Skills: Excel

See more: stl map counting, w split, we excel, time in az, service az, programs 4 computer, i need excel help, help find , find help, file download service, excel spreadsheet web service, excel special, dhl same day, database computer programs, excel split columns, programs computer, need excel help, computer programs, row b, reports in excel, report w, report from excel, help with computer, help computer, format excel

About the Employer:
( 0 reviews ) incinnati, United States

Project ID: #249834

Awarded to:


Hello,Pls view PMB. Thanks!

$60 USD in 1 day
(7 Reviews)

39 freelancers are bidding on average $141 for this job


VBA (Excel) developer since 1997. Can do. Regards, Svet.

$200 USD in 3 days
(56 Reviews)

Hello Please see PMB for details of my bid. Thank you

$200 USD in 2 days
(40 Reviews)

kindly Check PM

$225 USD in 7 days
(30 Reviews)

Please see PMB.

$150 USD in 5 days
(78 Reviews)

Please check PMB for details, Thank you

$250 USD in 4 days
(45 Reviews)

Looking forward to working with you.

$250 USD in 2 days
(14 Reviews)

Hello. I could do in Excel almost everything. Once I have done a self educating computer game with genetical algorithm. So this task will not be a problem. Sergey S. Look PM please.

$55 USD in 1 day
(10 Reviews)

Pl refer PM

$100 USD in 30 days
(7 Reviews)

I am looking forward to working with you. you will be impressed with my accuracy and 152wpm typing speed.

$150 USD in 2 days
(0 Reviews)

My aim is to provide all my skills and knowledge to you, even though I may be a thousand miles away. I can do any task that doesn’t need my physical presence and can be carried out over e-mail, telephone, fax and the i More

$145 USD in 2 days
(0 Reviews)

rates can be negotiated. Our company (Ideaaz) deals with all kind of processes, Our major business fields are web designing, graphic designing, data processing, data conversion, data entry, email appending, email pr More

$200 USD in 1 day
(0 Reviews)

My kwowledge are strong in MS Office and i think i can help you in this matter thank you

$130 USD in 2 days
(0 Reviews)

Pls chk PMB.

$50 USD in 1 day
(0 Reviews)

hi. ready when you are. i assume that this is a daily routine therefore a long term job? my bid is on a daily rate basis

$50 USD in 1 day
(0 Reviews)

Hi, I will do the job for you. Pl refer my PM. Regards/Pradeep

$50 USD in 1 day
(0 Reviews)

Pls chk PMB

$55 USD in 1 day
(0 Reviews)

Provide us and check our service.

$120 USD in 30 days
(0 Reviews)

Hey I am new in this world..But I hv experience to solve problems in excel in my previous emplyoer..So I can solve your problem..waiting for your response

$35 USD in 1 day
(0 Reviews)

I can do this job. as early as you want but depends on amount of sheets Secondlly yuo need seperate sheet in same document or threee different one please tell this and also about the jbo to be done in office 2003 or of More

$100 USD in 2 days
(0 Reviews)

Dear Sir I would like to work in your project , I will done the project very clear & fast.

$126 USD in 21 days
(0 Reviews)