Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Automatically create comments based upon cell value and related datain database [email protected] Excel Discussion (Misc queries) 3 April 10th 08 12:31 PM
How do I create a template that add the fields to a database? gvn Excel Discussion (Misc queries) 1 January 25th 06 08:25 PM
How to open xl and create a new document based on a template Colin Wilson Excel Discussion (Misc queries) 2 December 2nd 05 01:07 PM
Create database based on excel form Pitu Excel Discussion (Misc queries) 7 September 29th 05 09:06 PM
how to create and use a new spreadsheet based on a template Shady Excel Discussion (Misc queries) 3 April 3rd 05 09:50 PM


All times are GMT +1. The time now is 03:13 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"