Transfer of Cost Prices for Products from 1 Excel Sheet to Another
- or -
Post a project like this$$
- Posted:
- Proposals: 46
- Remote
- #2097932
- Expired
Data Entry, MS Excel work, PPT, Fallible PDF Form, PDF Conversion, Typing MS Word
Anand
23331582331991146701723210692152196233577321446272337210234004813747912082702332650
Description
Experience Level: Intermediate
The Task
Updating product cost prices and retail values from old spreadsheet into new sheet, so these can be uploaded into website.
I have initially 1,000 products from various suppliers, in different spreadsheet that need matching up, via SKU/Product Code, and the cost and retail values entering.
If a good job is done, I have another 8,000 that will need doing.
This could possibly done via VLookup I think.
I have attached a sample sheet of the supplier sheet, and the new CSV sheet that will be uploaded, so please have a look before bidding on the job.
Cost Prices and Retail ex VAT values to be taken from "AF Rayspeed Cost Prices" and entered into "AF Rayspeed List"
I need accuracy, care and speed for this job, must be done in the next few days.
Many Thanks,
Dan
Updating product cost prices and retail values from old spreadsheet into new sheet, so these can be uploaded into website.
I have initially 1,000 products from various suppliers, in different spreadsheet that need matching up, via SKU/Product Code, and the cost and retail values entering.
If a good job is done, I have another 8,000 that will need doing.
This could possibly done via VLookup I think.
I have attached a sample sheet of the supplier sheet, and the new CSV sheet that will be uploaded, so please have a look before bidding on the job.
Cost Prices and Retail ex VAT values to be taken from "AF Rayspeed Cost Prices" and entered into "AF Rayspeed List"
I need accuracy, care and speed for this job, must be done in the next few days.
Many Thanks,
Dan
Dan G.
100% (45)Projects Completed
24
Freelancers worked with
9
Projects awarded
78%
Last project
1 Jul 2021
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Hi Dan,
Can you provide another sample please? The suppliers list file doesn't seem to have any prices and it is not a useful CSV file. Thank you
Zoran -
Hi Dan,
are you able to adjust your budget?
cheers,
Agnes -
May I have the new sheet in excel format? as the csv is quite messy. Thanks :)
688263688199688196
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies