Excel Expert Needed! Show Off Your Skills!

In Progress

I need you to create 2 spreadsheets that do the same thing . This process should be simple if you know your excel . I have had one done

before but lost my sheet .. (sample only includes about 40 items, that you can show me you can do it, final sheet one will need to do about 30,000 items will provide final bidder actual information, Sheet 2 will have 1900 items to sort)

First Excel Sheet ..

I need to be able to drag and drop (cut and paste into a box within the sheet) information from one sheet ([url removed, login to view] example included) into another, have the sheet automatically sort the information, then match it to the information in the 2nd Sheet ([url removed, login to view] sheet included), the then ignore the other data on the sheet that is not needed or UPC codes not on the [url removed, login to view] . The Sheet needs to match up UPC from sheet 1 into sheet 2, then sort transfer the Quantity into sheet 2 ... Then I can save the output into .txt file

2nd Excel Sheet .. there are 3 steps involved in this one but only need to sort about 2500 items

I need to be able to drag and drop (cut and paste into a box within the sheet) information from one sheet ([url removed, login to view] example included) into another, have the sheet automatically sort the information, then match it to the information in the 2nd Sheet ([url removed, login to view] sheet included), the then ignore the other data on the sheet that is not needed or Item ID codes not on the [url removed, login to view] . The Sheet needs to match up Item ID from sheet 1 into sheet 2, then sort transfer the Quantity into sheet 2 ..., now in this 2nd sheet we have matched Item ID with a UPC and Quantity, a sheet output called [url removed, login to view] for this example/ Now the 3rd sheet/step would be be able to drag and drop (cut and paste into a box within the sheet) information from one sheet ([url removed, login to view] ) into another, have the sheet automatically sort the information, then match it to the information in the 2nd Sheet ([url removed, login to view] sheet included), the then ignore the other data on the sheet that is not needed or UPC codes not on the [url removed, login to view] . The Sheet needs to match up UPC from sheet 2 into sheet 3, then sort transfer the Quantity into sheet 3 ... Then I can save the output into .txt file

I know I have written a lot but the right person will know exactly what I want .. There is enough information for you to send me a small example and I will award the job to the person who understands the job and provides a functioning example ..

Thank You .. Check my rep and you will see I pay on time for job well done

Skills: Data Entry, Data Processing, Excel

See more: xls excel expert, who can expert in excel, what skills do i have, show your skills, one off job, job for excel expert, final cut job, file excel expert, expert excel job, excel expert up, excel expert skills, show skills, show me data entry, excel sheet expert, excel expert 2013, upc codes, sort excel, show me, show box, need a excel expert, lost excel, excel expert, drag drop excel, excel upc, save txt excel

About the Employer:
( 40 reviews ) Carthage, United States

Project ID: #4294124

Awarded to:

ZeusMan

Looking forward to working with you...

$80 USD in 2 days
(50 Reviews)
5.6

20 freelancers are bidding on average $88 for this job

sonarkaushik

Sir, I can do the project. Refer PMB. Looking for further discussions in this matter. with thanks and regards

$95 USD in 7 days
(59 Reviews)
5.7
srikartiram

Please read the PMB.

$40 USD in 2 days
(39 Reviews)
5.3
mrbrave

A quick job for me....

$70 USD in 1 day
(59 Reviews)
5.2
nayabsiddiqi

can provide you a quick and reliable solution

$80 USD in 0 days
(7 Reviews)
4.1
vikashgadia

we r excel vba expert

$70 USD in 2 days
(13 Reviews)
3.5
glddgunawardana

Dear Sir/ Madam, If you wish to get your work done accurately and timely you can rely on me. I'm here to provide you a better service possibly by meeting all your criteria. Please check the private message for detaile More

$75 USD in 3 days
(1 Review)
2.8
permana22sl

I can do this...

$50 USD in 1 day
(2 Reviews)
2.3
saravanan87

I can do this...

$100 USD in 1 day
(1 Review)
1.6
netquart

Hello, Let's start. Thanks.

$30 USD in 1 day
(1 Review)
0.2
leesei

I can do this for you.

$80 USD in 5 days
(0 Reviews)
0.0
MasterExcel

I am Data Entry Expert, MS Word and MS Excel. i know how to do your job and i am very much professional in this work i am pretty sure that you cant find a best person for this job like me so i am ready to work on your More

$30 USD in 2 days
(0 Reviews)
0.0
manishpandey7711

i have understand all n i like work wid u,, thanc.

$100 USD in 6 days
(0 Reviews)
0.0
krismani

See the PM

$100 USD in 1 day
(0 Reviews)
0.0
donaldmickey

ready to start here

$35 USD in 3 days
(0 Reviews)
0.0
softzpk92

Dear Hiring Manager, I am Interested in this Job, please review my detailed proposal for your consideration. Thanks

$80 USD in 2 days
(0 Reviews)
0.0
nishantkumar007

hello sir, i am capable in doing all kind of ms office work.

$200 USD in 30 days
(0 Reviews)
0.0
shivamagnihotri1

we are the best to work at excel ....that's why we want to work with you

$150 USD in 30 days
(0 Reviews)
0.0
mitan1987

I can perform well on this job because of accounting and costing related work i have good command over MS office.mitanb at the rate gmail dot com

$200 USD in 2 days
(0 Reviews)
0.0
vasilestefania20

Hy! I am a teacher and I want to work in this project.I work as an informatician since 2001. Thank You!

$78 USD in 3 days
(1 Review)
0.0
shofi39

Dear Sir, I am well versed in accounting as well as excel . Please consider me. Hope to hear from you soon. Shafikul Islam

$100 USD in 7 days
(0 Reviews)
0.0