Need Excel VBA macro written to re-format data for stock import

  • Posted:
  • Proposals: 10
  • Remote
  • #1982464
  • Completed
Sathish S.Colin B.Ian W.Valeriy S.Roy K. + 5 others have already sent a proposal.
  • 7

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:

New Proposal

Create an account now and send a proposal now to get this project.

Sign up

Clarification Board Ask a Question

  • Robert A.

    Simon,

    Can't see the spreadsheet you say at the beginning is attached? Can you add it so we can follow the description, please?

  • Md P.

    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