I have a spreadsheet of roughly 165 entries. I have created a form on a second tab in which I have placed formulas in 9 fields that populate those fields with data from specific cells on the master spreadsheet. There are no calculations in any of the fields, simply instructions to pull the data found in the related fields (i.e. "=Master!Q3").

I need a script that will do the following:
  1. Save the initial version of the form to a specified folder using the Street and Town fields as the filename.
  2. Print the initial version of the form.
  3. Update the form with data from the next row that is populated in the Address column.
  4. Save the second version of the form as in Step 1, to the same folder.
  5. Print the second version of the form.
  6. Repeat steps 3-5 until all rows populated in the Address column have been saved and printed.

That's pretty much it. I think I could manage writing a macro that would accomplish populating the form and printing it, but have no idea how to get it to save the form to a specified folder using a different filename for each form.

Thanks,
Henry