I'm trying to extract commission amounts for various sales reps from a table
with known number of columns but varying number of rows each month. I want to
extract values from certain columns and rows pertaining to each sales rep to
create a commission report and then a summary calculating the total pay for
each rep. The report comes from our servicing company and is not broken down
by sales rep. The table shows the name of the various companies who purchased
our product. We know which sales rep sold to which company, but the servicing
company doesn't. I need to create a report that summarizes each sales rep's
sales based on the company name for various products sold, all of which have
differing commission percentages. We have about 10 categories of products.
Where do I start?

look at a pivot table

--


Gary Keramidas
Excel 2003


"Gary" wrote in message
...
I'm trying to extract commission amounts for various sales reps from a
table
with known number of columns but varying number of rows each month. I want
to
extract values from certain columns and rows pertaining to each sales rep
to
create a commission report and then a summary calculating the total pay
for
each rep. The report comes from our servicing company and is not broken
down
by sales rep. The table shows the name of the various companies who
purchased
our product. We know which sales rep sold to which company, but the
servicing
company doesn't. I need to create a report that summarizes each sales
rep's
sales based on the company name for various products sold, all of which
have
differing commission percentages. We have about 10 categories of products.
Where do I start?

Thanks Gary!
I know about pivot tables for viewing information in various ways in a
table, but I want to automatically extract certain information from a table
and populate another Excel spreadsheet where I can do the commission
calculations. Then I want to populate another spreadsheet to summarize each
sales reps commissions and show total commissions paid to that sales rep and
the same information for all other sales reps. Again, the commission report
from the company is for all sales reps and is not broken down by sales rep.
The sales reps names are not even on the report. It's just a list of all the
products purchased by various companies from all the sales reps. We know
which company was sold by which rep and that's what I need to organize and
summarize from the raw unsorted, unallocated information from the company.

Gary

"Gary Keramidas" wrote:

look at a pivot table

--


Gary Keramidas
Excel 2003


"Gary" wrote in message
...
I'm trying to extract commission amounts for various sales reps from a
table
with known number of columns but varying number of rows each month. I want
to
extract values from certain columns and rows pertaining to each sales rep
to
create a commission report and then a summary calculating the total pay
for
each rep. The report comes from our servicing company and is not broken
down
by sales rep. The table shows the name of the various companies who
purchased
our product. We know which sales rep sold to which company, but the
servicing
company doesn't. I need to create a report that summarizes each sales
rep's
sales based on the company name for various products sold, all of which
have
differing commission percentages. We have about 10 categories of products.
Where do I start?

.

without a specific layout, i doubt you will get a total solution. what about
an autofilter? you could filter by company and then copy the data where you
need it.


--


Gary Keramidas
Excel 2003


"Gary" wrote in message
...
Thanks Gary!
I know about pivot tables for viewing information in various ways in a
table, but I want to automatically extract certain information from a
table
and populate another Excel spreadsheet where I can do the commission
calculations. Then I want to populate another spreadsheet to summarize
each
sales reps commissions and show total commissions paid to that sales rep
and
the same information for all other sales reps. Again, the commission
report
from the company is for all sales reps and is not broken down by sales
rep.
The sales reps names are not even on the report. It's just a list of all
the
products purchased by various companies from all the sales reps. We know
which company was sold by which rep and that's what I need to organize and
summarize from the raw unsorted, unallocated information from the company.

Gary

"Gary Keramidas" wrote:

look at a pivot table

--


Gary Keramidas
Excel 2003


"Gary" wrote in message
...
I'm trying to extract commission amounts for various sales reps from a
table
with known number of columns but varying number of rows each month. I
want
to
extract values from certain columns and rows pertaining to each sales
rep
to
create a commission report and then a summary calculating the total pay
for
each rep. The report comes from our servicing company and is not broken
down
by sales rep. The table shows the name of the various companies who
purchased
our product. We know which sales rep sold to which company, but the
servicing
company doesn't. I need to create a report that summarizes each sales
rep's
sales based on the company name for various products sold, all of which
have
differing commission percentages. We have about 10 categories of
products.
Where do I start?

.

Thanks again Gary! However, that's what the bookkeeper is doing now - copying
and pasting from one Excel spread sheet to another. It's tedious and time
consuming. I'm not convinced there's not an automatic solution. It's simply a
database and we need to extract certain information from it so we can create
commission reports for everyone. I don't believe I'm the first person to ever
need to do this. I simply want to convert raw data into meaningful data I can
use to calculate and pay commissions. I want to do this with as little effort
as possible.
Gary

"Gary Keramidas" wrote:

without a specific layout, i doubt you will get a total solution. what about
an autofilter? you could filter by company and then copy the data where you
need it.


--


Gary Keramidas
Excel 2003


"Gary" wrote in message
...
Thanks Gary!
I know about pivot tables for viewing information in various ways in a
table, but I want to automatically extract certain information from a
table
and populate another Excel spreadsheet where I can do the commission
calculations. Then I want to populate another spreadsheet to summarize
each
sales reps commissions and show total commissions paid to that sales rep
and
the same information for all other sales reps. Again, the commission
report
from the company is for all sales reps and is not broken down by sales
rep.
The sales reps names are not even on the report. It's just a list of all
the
products purchased by various companies from all the sales reps. We know
which company was sold by which rep and that's what I need to organize and
summarize from the raw unsorted, unallocated information from the company.

Gary

"Gary Keramidas" wrote:

look at a pivot table

--


Gary Keramidas
Excel 2003


"Gary" wrote in message
...
I'm trying to extract commission amounts for various sales reps from a
table
with known number of columns but varying number of rows each month. I
want
to
extract values from certain columns and rows pertaining to each sales
rep
to
create a commission report and then a summary calculating the total pay
for
each rep. The report comes from our servicing company and is not broken
down
by sales rep. The table shows the name of the various companies who
purchased
our product. We know which sales rep sold to which company, but the
servicing
company doesn't. I need to create a report that summarizes each sales
rep's
sales based on the company name for various products sold, all of which
have
differing commission percentages. We have about 10 categories of
products.
Where do I start?

.


.

i'm sure it could be automated, just not with the information provided.
you could email a sample or just post the detailed layout in the
programming group and there's a chance you will get a solution. but i'm
guessing it is going to entail writing some code.
--


Gary Keramidas
Excel 2003


"Gary" wrote in message
...
Thanks again Gary! However, that's what the bookkeeper is doing now -
copying
and pasting from one Excel spread sheet to another. It's tedious and time
consuming. I'm not convinced there's not an automatic solution. It's
simply a
database and we need to extract certain information from it so we can
create
commission reports for everyone. I don't believe I'm the first person to
ever
need to do this. I simply want to convert raw data into meaningful data I
can
use to calculate and pay commissions. I want to do this with as little
effort
as possible.
Gary

"Gary Keramidas" wrote:

without a specific layout, i doubt you will get a total solution. what
about
an autofilter? you could filter by company and then copy the data where
you
need it.


--


Gary Keramidas
Excel 2003


"Gary" wrote in message
...
Thanks Gary!
I know about pivot tables for viewing information in various ways in a
table, but I want to automatically extract certain information from a
table
and populate another Excel spreadsheet where I can do the commission
calculations. Then I want to populate another spreadsheet to summarize
each
sales reps commissions and show total commissions paid to that sales
rep
and
the same information for all other sales reps. Again, the commission
report
from the company is for all sales reps and is not broken down by sales
rep.
The sales reps names are not even on the report. It's just a list of
all
the
products purchased by various companies from all the sales reps. We
know
which company was sold by which rep and that's what I need to organize
and
summarize from the raw unsorted, unallocated information from the
company.

Gary

"Gary Keramidas" wrote:

look at a pivot table

--


Gary Keramidas
Excel 2003


"Gary" wrote in message
...
I'm trying to extract commission amounts for various sales reps from
a
table
with known number of columns but varying number of rows each month.
I
want
to
extract values from certain columns and rows pertaining to each
sales
rep
to
create a commission report and then a summary calculating the total
pay
for
each rep. The report comes from our servicing company and is not
broken
down
by sales rep. The table shows the name of the various companies who
purchased
our product. We know which sales rep sold to which company, but the
servicing
company doesn't. I need to create a report that summarizes each
sales
rep's
sales based on the company name for various products sold, all of
which
have
differing commission percentages. We have about 10 categories of
products.
Where do I start?

.


.