linking cellsto a table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Back
Top