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

Yes to your question, but (gathering information on a form), and (printing an
output) , (querys with that information?) Me, I would give serious
consideration to building that in Access if this is going to be a long term
operational program.

--
William<"M"




"MLK" wrote:

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,