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.

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.

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.

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 placefilter itand use the
data with SUBTOTAL.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Bruce Hancock" wrote in message
...
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.

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

"Bruce Hancock" wrote:

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.

How? As I said I am a novice.

"Darrilyn" wrote:

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

"Bruce Hancock" wrote:

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.

http://office.microsoft.com/en-us/he...563201033.aspx

This webite explains v and h lookups.

"Bruce Hancock" wrote:

How? As I said I am a novice.

"Darrilyn" wrote:

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

"Bruce Hancock" wrote:

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.