I want to populate a seperate spreadsheet for each sales person, listing
their sales only, from a master list.

I have been cutting and pasting. I am looking for a way to have the
seperate sheets filled by using a function to select each sales person and
post to their sheet.

I am unable to use the lookup functions because they only select the first
match. I have numerous rows for each person. Their is no other consistant
unique data to search from. My header consist of Sales Person, Date,
Customer, Invoice Number, Cases, Amount Earned.

The sales reports must list each invoice and be seperate for each person.

You may want to try Ron de Bruin's Easyfilter:
http://www.rondebruin.nl/easyfilter.htm

Or look at the way Debra Dalgleish does it:

Debra's site:
http://www.contextures.com/excelfiles.html

Create New Sheets from Filtered List -- uses an Advanced Filter to create
separate sheet of orders for each sales rep visible in a filtered list; macro
automates the filter. AdvFilterRepFiltered.xls 35 kb

or

Update Sheets from Master -- uses an Advanced Filter to send data from
Master sheet to individual worksheets -- replaces old data with current.
AdvFilterCity.xls 55 kb


jdall wrote:

I want to populate a seperate spreadsheet for each sales person, listing
their sales only, from a master list.

I have been cutting and pasting. I am looking for a way to have the
seperate sheets filled by using a function to select each sales person and
post to their sheet.

I am unable to use the lookup functions because they only select the first
match. I have numerous rows for each person. Their is no other consistant
unique data to search from. My header consist of Sales Person, Date,
Customer, Invoice Number, Cases, Amount Earned.

The sales reports must list each invoice and be seperate for each person.

--

Dave Peterson