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.