Thanks Don but that does not allow me to transfer only the data for salesman
1 to tab 1, saleswomen 2 to tab 2 etc.

"Don Guillett" wrote:

You don't need to create separate sheets. Have a look at
datafilterautofilter

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Bruce Hancock" wrote in message
...
Ladies and Gentlemen this is my problem;
I have a spreadsheet that has 3 tabs for details of sales including
profits.
I want to create a commission sheet for each salesperson and transfer only
the data that relates to that salesperson.

For example, I have a tabs labelled "New", "Used" and "VAT Qualifying".
These tabs are basically the same and include the name of the salesperson,
name of customer, stock number and profit amongst other things.

The other tabs I have are for the salespeople's commissions and needs to
read the dat from "New", "Used" and "VAT Qualifying" and copy over the
date
that relates only to a specific salesperson. i.e. tab 1 is "MM" and should
only have details of sales made by "MM" including the name, stock number
etc.

Be gentle with me because I am a bit of a novice in Excel.

Thank you.