Need Excel VBA macro written to re-format data for stock import
- Posted:
- Proposals: 10
- Remote
- #1982464
- Completed
Bangalore 
Description
Experience Level: Intermediate
General information for the business: We provide IT services for SME's
Kind of development: New program from scratch
Description of requirements/functionality: See attached spreadsheet.
2 Tabs.
Input:
This is the format in which the data is provided.
I have highlighted the first section in yellow. This is represented in the tab "output" in the format that it needs to appear.
Output:
This indicates the format into which the data needs to be translated.
The SKU is a concatenation of the SKU in the input tab, the colour and the size.
The description is, well, the description from the first line
The stock date
…and the quantity of stock for each variant.
Where it indicates and "x" this means there will be no stock available so parameter should be set to 0
Where it indicates an "ok" this means there is ample stock available so parameter should be set to an arbitrarily high number of "1000"
OS requirements: Windows, Mac OS
Extra notes:
Kind of development: New program from scratch
Description of requirements/functionality: See attached spreadsheet.
2 Tabs.
Input:
This is the format in which the data is provided.
I have highlighted the first section in yellow. This is represented in the tab "output" in the format that it needs to appear.
Output:
This indicates the format into which the data needs to be translated.
The SKU is a concatenation of the SKU in the input tab, the colour and the size.
The description is, well, the description from the first line
The stock date
…and the quantity of stock for each variant.
Where it indicates and "x" this means there will be no stock available so parameter should be set to 0
Where it indicates an "ok" this means there is ample stock available so parameter should be set to an arbitrarily high number of "1000"
OS requirements: Windows, Mac OS
Extra notes:
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Simon,
Can't see the spreadsheet you say at the beginning is attached? Can you add it so we can follow the description, please? -
Hello Simon,
what is the timeline for that? Could you please invite me to chat with you about this job, see if i can help you?
Cheers,
Prince