View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Marilyn Marilyn is offline
external usenet poster
 
Posts: 211
Default Extract data from form

MLK I have the same problem. How did you solve this? Thanks

rote:

I created a form template that contains checkboxes and dropdowns (using forms
toolbar, not control).

This form is then used by a number of people and they save their updated
form into a folder (their output is the form template with their checkbox and
list selections).

Currently I view each form and manually take the results and enter the data
into a master sheet.

In the future, is there a way for the users to save the form output so that
the results appear in spreadsheet format with all the data on 1 row?

Thanks,