Hello. Brand new to VBA. I often get word files with test items that need to be converted to Excel in horizontal. So something like this:
line1 ItemID
line2 text of question (may be multiple lines)
line3 answerchoice1
line4 answerchoice2 ... through 4 to 8 answer choices.
Next line reference
next line other text.


I want each element to be in a column across an excel doc. Can anyone help?