Compiling Data from excel survey....Is it even possible to accomplish what i want?

[2clacaze]

So, I created an Excel Survey to ask new customers to our powder-coating business to provide the vital information regarding their work orders that is badly missed on their hand-written P.O.s, and in the never-ending struggle to make life easier, I thought, "Self, you should really try to get the info from the survey to populate itself into that snazzy new Excel Work Order Form you created."

Problem is, the survey stores to an online excel file, my workbook and all of its macros to save and generate a new Work Order are offline. Furthermore, it would seem that the survey stores the information in a row dedicated to that session. Meaning that eventually there will be thousands of entries.

Can I parse that line out to populate my work order without having to write a new macro for each line? Or would i set a macro to populate a work order from Row 1, and then deleting that row, effectively "processing" that information on down the line and shifting the next set of survey responses up to fill the void?

Took screenshots to help you understand, but for the life-of-me, I cant figure how to upload them in this forum.....

 

[Kenneth Hobson]

Most would use an MSWord mail merge to do that sort of thing. Here is an example. https://www.dropbox.com/s/fx4r06xq4mnlan6/ElephantsRusDocs.zip?dl=0

This file pokes each row of data in a sheet into a sort of "work order" form on another sheet. It then makes a PDF with all of the "work orders".
https://www.dropbox.com/s/5ikzsfcqquioxgd/ScratchWorkbookSheetsToOnePDF.xlsm?dl=0