In need of a simple macro in excel which formats multiple columns into three columns according to a certain pattern.
The "Data"-sheet contains the raw-data which i want formated into the second sheet "Magmi". The result need to be based on the amount in column A "sku" in the "data"-sheet.
There's a sample result in the "magmi" sheet now with values from columns C and D, but we want the script to do the same for all columns.
What we want the script to do:
Copy the amount in column A as well as the values in column C into column B and C of sheet "magmi", then i want the value of C1 from "data" sheet to fill column A in "magmi" sheet.
Repeat until the values from all columns C-Q in "Data" sheet are copied the same amount of times as the amout of values in column A in "Data" sheet together with the value from row 1 "Data" sheet into the "Magmi" sheet.
17 freelancers are bidding on average $28 for this job
Hi, I have seen your proposal. I am an excel expert with very good knowledge of VBA. I can do this task Please come on chat for more details. Awaiting your response. Thank you.
hi, I am very good in Excel vba, macro, chart etc. if you want to see my excel skills i can share with you some of my work on excel. I feel fit myself for this project. please contact with me. Thanks.
Hello! I have experience in Microsoft Excel and Visual Basic for Applications. I can create a macro on VBA for you in short time. Clear code with comments guarantee!