Transferring data from one sheet to another if criteria are met.

[Guest]

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.

 

[Don Guillett]

You don't need to create separate sheets. Have a look at
data>filter>autofilter>

 

[Guest]

You can pull in the data to each salesperson sheet by using vlookups and
hlookups.

 

[Guest]

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.

 

[Guest]

How? As I said I am a novice.

You can pull in the data to each salesperson sheet by using vlookups and
hlookups.

 

[Guest]

http://office.microsoft.com/en-us/help/HA010563201033.aspx

This webite explains v and h lookups.

 

[Don Guillett]

As I said, if you do it right you need NOT make separate sheets. Autofilter
is designed to let you keep all the data in one place>filter it>and use the
data with SUBTOTAL.