vlookup?

[Gary]

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?

 

[Gary Keramidas]

look at a pivot table

 

[Gary]

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]

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]

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]

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.