I would like to hire an Excel Expert

This project was successfully completed by schoudhary1553 for $30 USD in a day.

Get free quotes for a project like this
Project Budget
$10 - $30 USD
Completed In
1 day
Total Bids
Project Description

We are importing data into a new ERP system and I need to create an automated Excel sheet where we can convert the price lists into importable data. Example: I have a price list with several columns of data that have to copied to the correct columns in the import template. Check column header, and copy to same column header in import spreadsheet. That's the easy part. The hard part is each product line has 9-12 price lists in columns that have to be transferred to the import spread sheet, but they must be inserted in rows below the product. Row 3 is Widget so Price lists 1-12 have to be copied to a specific cell in row 4, 5, 6, 7, 8, 9, 10, 11, etc...leaving the complete line blank except for the price list reference and the price of the product. Line above determines the product, lines below fill in the each price list price. It has to repeat this for the whole spreadsheet. Anyone?

Completed by:
Skills Required

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