View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
M John
 
Posts: n/a
Default Move Word form to Excel

Alternatively, a macro that would pull out all the user entered data from the
9-page Word file and drop that into a selected column in an Excel
file...would (maybe?) be easier?
Again, thanks ahead of time,
MJohn

"M John" wrote:

Hello,
I have 9 page outline-bulletized questionnaire / form in Word with drop down
lists, text boxes, and check boxes. I've explored Excel's 'form making'
abilities and the data validation and really like the ability to manipulate
the replies/answers (sort, filter, etc.) and the ability to do it quickly and
comparatively painlessly. I would like to migrate the 9 page Word form into
Excel. I recognize that the text boxes and drop down lists won't survive the
move, but is there away to move the bulletized list while retaining the
indents and other formatting features to Excel? I've tried copying from Word
to Notepad, saving it there, and then opening with Excel, but the numbers,
letters, are all left aligned. Any solutions / ideas?
Many thanks in advance,
MJohn