View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Don Guillett Don Guillett is offline
external usenet poster
 
Posts: 10,124
Default Best way to set up Excel customer list?

If you use the datafilterautofilter then there is probably no reason not
to have all on ONE sheet.
Have a column for date, customer, etc.
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Pianotech" wrote in message
...
Hi all, I'm new to Excel, having used MS Works for a customer
list/database
for many years. I'm trying to decide whether it would be best to have:

1. A single Excel workbook with my entire customer list on one worksheet
or
2. Seperate workbooks for each month
or
3. A single workbook with worksheets for each month.

My goal is to easily be able to select customers from a certain month and
export their contact information to direct mailers, etc, for promotional
and
reminder mailings, etc.

Thanks for the advice..

--PT