Thread
:
Best way to set up Excel customer list?
View Single Post
#
2
Posted to microsoft.public.excel.newusers
Don Guillett
external usenet poster
Posts: 10,124
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
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett