Create a printable FORM
 

I need to create a FORM that prints data rather than enters data - odd I
know. The forms are certificates required by regulation. So, data is
entered into a table and then merged into a FORM that is printed on the print
command.

I have created an Excel template but this may work better as a Word and
Excel merge?

Create a printable FORM
 

Michell,

Here's the general technique.

Let's say that your data is on sheet "Data" in columns A to Z, and you have a sheet "Print Form"
that is nicely formatted, with spaces for your desired data. Let's also say that your data table has
unique identifiers in column A, which we'll call the data key.

On the print form, use one cell as the index cell, where you will enter the values from the data key
column of your data table. Then for all the fields that your want to display, use VLOOKUP formulas
that extract the relevant data from the data table, based on that key value.

For example, enter "Michell" in cell A1 of "Print Form" and in cell A2, use the formula

=VLOOKUP(A1, Data!$A1:$Z1000,4,False)

to pull the data from column D of the data table where the key value in column A = Michell.

And so on, and so on.

HTH,
Bernie
MS Excel MVP


"Michell Major" wrote in message
...
I need to create a FORM that prints data rather than enters data - odd I
know. The forms are certificates required by regulation. So, data is
entered into a table and then merged into a FORM that is printed on the print
command.

I have created an Excel template but this may work better as a Word and
Excel merge?

Create a printable FORM
 

Bernie. Thanks, I'll give it a go over the weekend. Dan

"Bernie Deitrick" wrote:

Michell,

Here's the general technique.

Let's say that your data is on sheet "Data" in columns A to Z, and you have a sheet "Print Form"
that is nicely formatted, with spaces for your desired data. Let's also say that your data table has
unique identifiers in column A, which we'll call the data key.

On the print form, use one cell as the index cell, where you will enter the values from the data key
column of your data table. Then for all the fields that your want to display, use VLOOKUP formulas
that extract the relevant data from the data table, based on that key value.

For example, enter "Michell" in cell A1 of "Print Form" and in cell A2, use the formula

=VLOOKUP(A1, Data!$A1:$Z1000,4,False)

to pull the data from column D of the data table where the key value in column A = Michell.

And so on, and so on.

HTH,
Bernie
MS Excel MVP


"Michell Major" wrote in message
...
I need to create a FORM that prints data rather than enters data - odd I
know. The forms are certificates required by regulation. So, data is
entered into a table and then merged into a FORM that is printed on the print
command.

I have created an Excel template but this may work better as a Word and
Excel merge?