HOW DO YOU SET UP A CONTENTS PAGE OF EXCEL DATA
 

Im trying to create a database of customers who have purchased a number of
products. on each product page will be a list of customers, from these list
of customers i want a contents oage to be auto populated with their names and
onyl ensure that they appear once. i also want to have in place a tick sheet
to if the customer appears on more than one page.

HOW DO YOU SET UP A CONTENTS PAGE OF EXCEL DATA
 

It would more straight forward to setup in a database application, e.g.
Access.

NickHK

"Help Me Please" <Help Me wrote in message
...
Im trying to create a database of customers who have purchased a number of
products. on each product page will be a list of customers, from these
list
of customers i want a contents oage to be auto populated with their names
and
onyl ensure that they appear once. i also want to have in place a tick
sheet
to if the customer appears on more than one page.

HOW DO YOU SET UP A CONTENTS PAGE OF EXCEL DATA
 

See http://www.mvps.org/dmcritchie/excel...c.htm#buildtoc


--
HTH

Bob Phillips

"Help Me Please" <Help Me wrote in message
...
Im trying to create a database of customers who have purchased a number of
products. on each product page will be a list of customers, from these
list
of customers i want a contents oage to be auto populated with their names
and
onyl ensure that they appear once. i also want to have in place a tick
sheet
to if the customer appears on more than one page.

HOW DO YOU SET UP A CONTENTS PAGE OF EXCEL DATA
 

Nick,
Yeah im open to suggestion but i dont know how i need to go about it, as you
can imagine its a large task with over 15,000 customers, im talking about
90,000 + lines, id be open to any suggestions


"NickHK" wrote:

It would more straight forward to setup in a database application, e.g.
Access.

NickHK

"Help Me Please" <Help Me wrote in message
...
Im trying to create a database of customers who have purchased a number of
products. on each product page will be a list of customers, from these
list
of customers i want a contents oage to be auto populated with their names
and
onyl ensure that they appear once. i also want to have in place a tick
sheet
to if the customer appears on more than one page.

HOW DO YOU SET UP A CONTENTS PAGE OF EXCEL DATA
 

bob,
im unsure how i would go about linkin with the code, i dont have anything
else to use, i am limited to certain programs, i dont have visual basic or
even an sql server. Can you help.
Email add
"Bob Phillips" wrote:

See http://www.mvps.org/dmcritchie/excel...c.htm#buildtoc


--
HTH

Bob Phillips

"Help Me Please" <Help Me wrote in message
...
Im trying to create a database of customers who have purchased a number of
products. on each product page will be a list of customers, from these
list
of customers i want a contents oage to be auto populated with their names
and
onyl ensure that they appear once. i also want to have in place a tick
sheet
to if the customer appears on more than one page.

HOW DO YOU SET UP A CONTENTS PAGE OF EXCEL DATA
 

Well,
If you are talking big numbers like that you will save yourself headaches in
the future by going with a database backend and possibly using Excel as a
front end.
Database-wise, Access is easy to set-up, or you have the free MySQL for a
real DB-management system.

As far as I remember, Access has various wizards available that would
construct the basic structure for you. After that you could either use
DataGet External DataNew Database Query or Pivot Tables in Excel to
display desired results.

NickHK

"Help Me Please" wrote in message
...
Nick,
Yeah im open to suggestion but i dont know how i need to go about it, as
you
can imagine its a large task with over 15,000 customers, im talking about
90,000 + lines, id be open to any suggestions


"NickHK" wrote:

It would more straight forward to setup in a database application, e.g.
Access.

NickHK

"Help Me Please" <Help Me wrote in
message
...
Im trying to create a database of customers who have purchased a
number of
products. on each product page will be a list of customers, from these
list
of customers i want a contents oage to be auto populated with their
names
and
onyl ensure that they appear once. i also want to have in place a tick
sheet
to if the customer appears on more than one page.

HOW DO YOU SET UP A CONTENTS PAGE OF EXCEL DATA
 

Hi Nick,
I only have the basic packages no SQL servers etc. This is hwy its so
difficult for me to complete the task. Ive created the tables in access and
have linked by relationships but im not sure if it will work, i want to try
and only have 15,000 client names rather than that one name repeated four or
five times becuase of what they have purchased.

are you any good with using access,
my email address is

it might be easier to communicate that way.

Thanks
"NickHK" wrote:

Well,
If you are talking big numbers like that you will save yourself headaches in
the future by going with a database backend and possibly using Excel as a
front end.
Database-wise, Access is easy to set-up, or you have the free MySQL for a
real DB-management system.

As far as I remember, Access has various wizards available that would
construct the basic structure for you. After that you could either use
DataGet External DataNew Database Query or Pivot Tables in Excel to
display desired results.

NickHK

"Help Me Please" wrote in message
...
Nick,
Yeah im open to suggestion but i dont know how i need to go about it, as
you
can imagine its a large task with over 15,000 customers, im talking about
90,000 + lines, id be open to any suggestions


"NickHK" wrote:

It would more straight forward to setup in a database application, e.g.
Access.

NickHK

"Help Me Please" <Help Me wrote in
message
...
Im trying to create a database of customers who have purchased a
number of
products. on each product page will be a list of customers, from these
list
of customers i want a contents oage to be auto populated with their
names
and
onyl ensure that they appear once. i also want to have in place a tick
sheet
to if the customer appears on more than one page.