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

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,