My manager needs form data to be output to a spreadsheet in a particular order -- not the order the data occurs in the file (which is logical to the tech filling out the form), but in the order that makes sense for data interpretation.
Acrobat 8 exports form data in the order it occurs in the file. I've tried renaming the data field names (e.g., A_CustomerName, B_CustomerID, etc.) to try to force the output order, but no joy.
Does anyone have a trick for doing this?
='Base Data'!B2
B2 being the cell in the from Base Data sheet.
Sheet formatted data looks nice, has the right column headings etc and the code calls each cell into the formatted proper cell.
I can email if you need further assistance.