Completed

Excel Expert Needed! Show Off Your Skills!

This project was successfully completed by ZeusMan for $80 USD in 2 days.

Get free quotes for a project like this
Employer working
Completed by:
Skills Required
Project Budget
$30 - $250 USD
Completed In
2 days
Total Bids
21
Project Description

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

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online