software

I want to produce a template with a couple of boxes, one of which will
contain a name and the other, a reference number. How can I input the details
into a table which will then transfer the data to the template automatically?
I need to produce a new template for each name and number so I will reproduce
one below the other and then print the selected area. I know I could type in
the info to the templates but it will take longer. Any help much appreciated.Corby --

It sounds like your problem lends itself to a VLOOKUP or HLOOKUP function.
The documenation is pretty good for these functions. Use them with a Named
Range function (again, pretty well documented) to make them easiest.

HTH

quot;THE CORBY LOONquot; wrote:

gt; I want to produce a template with a couple of boxes, one of which will
gt; contain a name and the other, a reference number. How can I input the details
gt; into a table which will then transfer the data to the template automatically?
gt; I need to produce a new template for each name and number so I will reproduce
gt; one below the other and then print the selected area. I know I could type in
gt; the info to the templates but it will take longer. Any help much appreciated.
gt;