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