Create and populate multiple copies of form in Excel RRS feed

  • Question

  • Dear Forum,

    I need to create several copies of a printable form in Excel, with data from a list populating two of the cells on each form.  For the purposes of this discussion, let us set the following parameters.  The data are in two columns, "Number" and "Name," on a sheet called, "Data."  There is a Form on a sheet called, "Form."  The form has 40 rows and 10 columns.  I want to put the data from the first row of Data in the "Number" column in cell B2 of the Form, and the data from the "Name" column in Cell D2.  For each row of data in the Data sheet, I want to create a new copy of the Form (on the same tab), with data from the corresponding row in the proper cells.  Each form should print as a single page.  So if I have 10 rows of data on the Data Sheet, I should get 10 copies of the Form.

    I would expect the code would do the following steps.

    1. Count the number of rows of data ("PageCount")

    2. Copy the form "PageCount" number of times

    2a. insert page breaks

    3. Copy and paste the data in the rows into the proper cells

    Thank you in advance for your help.

    Friday, October 5, 2012 2:28 PM


All replies