Automatically update an Excel Spreadsheet
- or -
Post a project like this1594
£50(approx. $62)
- Posted:
- Proposals: 7
- Remote
- #2631032
- Completed
PPH TOP (79 Experts)Logo Designer|Graphic designer| Architect| Explainer Video Creator| Animator |Proofread|3D design | |Photoshop |
Rupnagar
Marketing, Data Entry, Pdf converter, MS office, Excel, Powerpoint
Thiruvananthapuram
2461489278063133966703406134341295234179073418106
Description
Experience Level: Entry
Estimated project duration: 1 day or less
Objective: to keep a master excel spreadsheet (used as shopify csv upload) from a source excel spreadsheet.
Key Tasks:
1. If possible access the source spreadsheet from a website homepage, post login (it is available as a link in the header)
2. Using the SKU column as the unique reference, update in the master sheet from the source:
- Inventory Quantity column
- R.R.P. column
- Cost Price (this would be from the lowest across three columns in the source sheet)
3. Not required daily, if possible to have as an optional when required or as part of daily update to flag in the master sheet if the product EAN number is different compared to the source file
4. Generate a csv file of the master sheet following the updates
For microsoft office, this would operate within office for mac. Alternatively happy for this to be moved to a Zoho sheet if easier
Key Tasks:
1. If possible access the source spreadsheet from a website homepage, post login (it is available as a link in the header)
2. Using the SKU column as the unique reference, update in the master sheet from the source:
- Inventory Quantity column
- R.R.P. column
- Cost Price (this would be from the lowest across three columns in the source sheet)
3. Not required daily, if possible to have as an optional when required or as part of daily update to flag in the master sheet if the product EAN number is different compared to the source file
4. Generate a csv file of the master sheet following the updates
For microsoft office, this would operate within office for mac. Alternatively happy for this to be moved to a Zoho sheet if easier
Dave M.
100% (1)Projects Completed
1
Freelancers worked with
1
Projects awarded
100%
Last project
4 Dec 2019
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
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