new to group and needing help

E

english2

I need to create a database which will be a customer list on sheet 1 but I
want each customer to have a second "action sheet" attached or linked to that
customer so I can keep up with their individual account. Creating the first
list is easy enough - it's your basic contact informaiton list - but how do I
create an action sheet for each person on the list and how do I link the
first sheet to all the others?
 
E

english2

Excel 2000 - I thought this was the group for Excel Templates? I can upgrade
to Excel 2003 if that makes a difference.

JoAnn Paules said:
What program and version? I would recommend posting your question in a
newsgroup for that program rather than a miscellaneous template group.

--

JoAnn Paules
MVP Microsoft [Publisher]

~~~~~
How to ask a question
http://support.microsoft.com/KB/555375


english2 said:
I need to create a database which will be a customer list on sheet 1 but I
want each customer to have a second "action sheet" attached or linked to
that
customer so I can keep up with their individual account. Creating the
first
list is easy enough - it's your basic contact informaiton list - but how
do I
create an action sheet for each person on the list and how do I link the
first sheet to all the others?
 
J

JoAnn Paules

It's for all templates but since your issue is dealing with Excel more than
it is an issue about the template, I would still contact the fine Excel
folks.

--

JoAnn Paules
MVP Microsoft [Publisher]

~~~~~
How to ask a question
http://support.microsoft.com/KB/555375


english2 said:
Excel 2000 - I thought this was the group for Excel Templates? I can
upgrade
to Excel 2003 if that makes a difference.

JoAnn Paules said:
What program and version? I would recommend posting your question in a
newsgroup for that program rather than a miscellaneous template group.

--

JoAnn Paules
MVP Microsoft [Publisher]

~~~~~
How to ask a question
http://support.microsoft.com/KB/555375


english2 said:
I need to create a database which will be a customer list on sheet 1 but
I
want each customer to have a second "action sheet" attached or linked
to
that
customer so I can keep up with their individual account. Creating the
first
list is easy enough - it's your basic contact informaiton list - but
how
do I
create an action sheet for each person on the list and how do I link
the
first sheet to all the others?
 
B

Bart

english2...
It can be done but Excel is not a true Database even though you can make it
function as one on a limited basis.
You really need to utilize Access and you can import your Customer list into
access and the go in to the access program and create a "action plan" table
then link the two tables together. Access is actually one of the best
"relational" databases going.
If you are unfamiliar with Access and need help contact me at:
(e-mail address removed)
386-441-1915
I would love to help you develop your database as this is what I did before
I retired and do now on a limited basis when people need help
Bart Ryle
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top