Hello all,
I have a word doc that has a form in it. The form may have any number of fields (boxes) to type text answers into, or be a drop down list to select an answer from. I need an excel macro that extracts all data from the form, but with every sixth field starting a new row in excel. So all data from the form will appear within 5 columns in an excel spreadsheet.
Is that possible? I have had no luck to do it myself.
Sample form attached, thank you.
____________________________
sample.doc