sorting data

C

Carl

I have a large database that I want to sort by postcode - and depending on
postcode - allocate that list to a specific salesperson. Iwant excel to give
me a report per person - with the relevant contacts listed.

What is the best way to do this???

Please reply to [email protected]

Regards
 
D

David McRitchie

If you want simple you can use a filter and separately filter and print.
http://www.contextures.com/techtips.htm for Excel tips look for filters

Otherwise you would need a macro. There are a lot of things you can
do in a macro. You could obtain the name, email address, postal codes
create a workbook or page and email it to the salesperson with their contacts.
 
Top