| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
linking cellsto a table
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. |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
linking cellsto a table
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 "THE CORBY LOON" wrote: 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Linking parameter query from Access to pivot table in Excel | Excel Discussion (Misc queries) | |||
| Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
| Linking to a pivot table from a formatted invoice | Links and Linking in Excel | |||
| Linking table in Excel to word | Links and Linking in Excel | |||
| Pivot Table Linking | Excel Discussion (Misc queries) | |||
Hybrid Mode
