Excel Spreadsheet Work

This project received 6 bids from talented freelancers with an average bid price of $31 USD.

Get free quotes for a project like this
Project Budget
Total Bids
Project Description

You will see attached 2 excel sheets:

[url removed, login to view]

[url removed, login to view]

[url removed, login to view] contains our pricing info only. For each product, you can see the discount level, and by formula that caculates Nett price (From list price). The last column called "Our Sale Price" contains a custom formula for each product, for some products it is based on nett price and for some based on list price. Remember each formula for each product is different to calculate "Our Sale Price"

[url removed, login to view] is our main file and contains all our product data (those columns are hidden but you can unhide them)

We need the Disc column data from [url removed, login to view] copied accross to the same column for the same product in Blank.xlsx. The products are in different orders in both xlsx so you will have to do by macro which copies where corresponding product ref matches. Also need you to copy Nett price and Our sale price in the same way.

Obviously the most important thing is you copy the right data to the right product. And also that the formulas work when copied into new sheet and show the same price after calculation. We do not want the spreadsheets to be linked.

We have copied 1 example in the top row of [url removed, login to view]

This is a simple low budget project, will be awarded to whoever has the best balance of price and feedback, but we will also accept new members.

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