sorting data

[Guest]

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 (e-mail address removed)

Regards

 

[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.