Attached is a spreadsheet with 3 worksheets, '[url removed, login to view]' (described below), as well as your previous work and macro. (How to copy a [url removed, login to view])
The first, CSV Export from Excel, shows what the data looks like when I export it from the website. This does not include the new work order fields.
The second worksheet shows what the data looks like after the macro has been run. You can see the Macro if you go to Developer, Visual Basic. But if you need a copy, I can send it as well.
The third is the worksheet with the Work Order Fields and Approved Field
This is what I need to change:
· The ‘Work Order #’ fields needs to be added to the Macro. So when I export form Excel, it will include the extra fields (which you’ve already set up) The Macro needs to be modified to include these fields so that it takes the information from a horizontal line, into listing the information vertically.
· I would also need the same thing done to the ‘approved’ field as well.