In Progress

Excel Spreadsheet Work

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: Data Entry, Data Processing, Excel

See more: excel spreadsheet work, price excel spreadsheet work, we excel, top work, project work example, product pricing spreadsheet, price list excel formula, matches list, list matches, data entry work linked in, custom list in excel, custom formulas in excel, best excel spreadsheets, excel nett price list price, excel spreadsheets work, excel formula nett price, new excel, excel spreadsheet formula, excel sheet formula, budget spreadsheet, xlsx, spreadsheet 2, row spreadsheet, pricing excel, price excel

About the Employer:
( 23 reviews ) Sutton, United Kingdom

Project ID: #596469

6 freelancers are bidding on average $31 for this job


Hi, please view my PM for more details, thanks.

$30 USD in 0 days
(106 Reviews)

Will complete, expert in excel pls check PM.

$30 USD in 0 days
(47 Reviews)

Hey, i am ready to work you right now. looking forward from you soon. Please see PMB Thanks

$30 USD in 0 days
(1 Review)

hey i am ready to work in exel.. please provide me details of the work.

$30 USD in 0 days
(0 Reviews)

Can start now if you are ready. 12 + Years in data entry for large corporation.

$30 USD in 0 days
(0 Reviews)

I understand the need for accuracy here and this is [login to view URL] forward to a mutually beneficial working relationship. Thanks.

$38 USD in 1 day
(0 Reviews)