I need a macro to loop through order template, extract each order and create one flat excel file
with one row for each order.
So it should do:
-prompt for a directory location x
- for each file in directory, x:
a. open the file and look for a tab "order"
b. copy specific header fields from the order like customer name etc
c. copy each row of detail such as sku and order qty (there will be one row per sku)
d. write the above (one row of output per material will be written, with headers repeated
for each row)
The result will be one large file per directory
41 freelancers are bidding on average $104 for this job
Hello, I’m an Excel VBA expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards. Stay tuned, I'm is still working on this proposal.
Hello, i am ready to start the project. I am very much interested in this task. Relevant Skills and Experience Data Entry Proposed Milestones $55 USD - Default