In Progress

EXCEL HELP

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, service az, find help, file download service, excel spreadsheet web service, excel special, dhl day, database computer programs, excel split columns, programs computer, need excel help, computer programs, row b, report w, help computer, format excel, excel w, excel us, excel service, excel reports, excel report, excel form, excel 7

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

Project ID: #249834

Awarded to:

Arenabpo

Hello,Pls view PMB. Thanks!

$60 USD in 1 day
(7 Reviews)
4.4

39 freelancers are bidding on average $141 for this job

svet63

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

$200 USD in 3 days
(56 Reviews)
6.5
schandraram

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

$200 USD in 2 days
(40 Reviews)
5.9
imranamin

kindly Check PM

$225 USD in 7 days
(30 Reviews)
5.4
best4best

Please see PMB.

$150 USD in 5 days
(78 Reviews)
5.3
dataconsultants

Please check PMB for details, Thank you

$250 USD in 4 days
(45 Reviews)
5.1
xamdam91

Looking forward to working with you.

$250 USD in 2 days
(14 Reviews)
4.1
SergeyPlus

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)
4.0
edatawiz

Pl refer PM

$100 USD in 30 days
(7 Reviews)
3.3
asiwaju

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)
0.0
danielcodrea

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)
0.0
stysuresh

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)
0.0
cristinell

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)
0.0
ain1976

Pls chk PMB.

$50 USD in 1 day
(0 Reviews)
0.0
crismiyagi1512

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)
0.0
jpradeepus

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

$50 USD in 1 day
(0 Reviews)
0.0
flc9000

Pls chk PMB

$55 USD in 1 day
(0 Reviews)
0.0
ravi1111

Provide us and check our service.

$120 USD in 30 days
(0 Reviews)
0.0
connected4u

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)
0.0
sanambusy

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)
0.0
sshahul1982

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)
0.0