Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using a database to create new worksheets based from a template
Hello,
This might be a rather easy question for some, or I may have complicated it beyond what it needs to be. Maybe I can simplify it, but nonetheless, I need help. I'm not a programmer and I have a vague grasp of any programming code. Ok, I hope i can describe this so that other people can understand it. Here we go: I have a database of information regarding addresses, phone numbers, customer names, etc. and I've made a template for the way it should be displayed. The layout of the information is as follows: name joe smith jane smith dwayne jones jeremy jones address 123 park 456 fareway 123 circle 123 square city clark clark harken harken state ak ak ak ms I'm wondering if I can make the template use variables instead of specific references, example: =concatenate(data!b1, "months", data!b2) I want for each column of information to be copied to a new worksheet using the template. If anyone needs more information to help clear up anything, I'll be glad to help. Thank you, Josh. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automatically create comments based upon cell value and related datain database | Excel Discussion (Misc queries) | |||
How do I create a template that add the fields to a database? | Excel Discussion (Misc queries) | |||
How to open xl and create a new document based on a template | Excel Discussion (Misc queries) | |||
Create database based on excel form | Excel Discussion (Misc queries) | |||
how to create and use a new spreadsheet based on a template | Excel Discussion (Misc queries) |