linking cellsto a table

[THE CORBY LOON]

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.

 

[pdberger]

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