Need Help with complex formula

T

TJF

:confused: I want to be able to have a cell paste to another worsheet in
the workbook.

I have finished the salesmans worksheets and now the I need a way for
the information based on a name to find the correct worksheet and then
the correct range (2 lines with a single name) based on a name in a
column and then the correct line based on a comapny name in a column
(the sales & PM work for 2 companies)

We have 12 sales people and 4 project managers and sometimes a project
manager may work some small projects for as many as 5 project managers.
Most times it is 3 but not always

I am making seperate worksheets for each salesman and each project
manager, I also have a seperate worksheet for lists and commission
rates.

Please Help
TJF
 
J

JE McGimpsey

First, a function in a cell can only return a value to that cell. It
can't directly input information into another cell.

Perhaps someone else will understand the situation better, but I can't
get a good handle on what you're trying to accomplish. Post back with a
more complete description, including range and cell references. I'm sure
it makes perfect sense to you, since you've been working on it
extensively, but I can envision many layouts that could fit your
description..
 
T

TJF

Thanks for Helping.

On my commission worksheet for the salesman I post in a row the sale
and cost of goods, then calculate the percentage of profit and furthe
calculate a percentage for commission, then further calculate th
salemans commission portion and the project managers commissio
portion. In the same row I have the project managers name and the nam
of this worksheet is the salemans name.

Now I need to find a way to get that project managers commission to hi
worksheet. The kicker is that it is not always the same project manage
assigned to the same salesman. I would like to know of a way for Exce
to check the names on the salesman worksheet then find the appropriat
project managers worksheet (by name) and then place in the appropriat
cell next to the name of the each salesman that the project manager ha
worked for. i.e Mark is the salesman John is the PM and the progra
would need to look at the line with the Johns name on the Marks sheet
then find Johns sheet, then find Marks name and place the amount nex
to that.

Would or anyone know how to check a name, then find a name of
worksheet, then grab information an place on that sheet. I could eve
put it all in a macro and just run that once the sales worksheets ar
done.

Thanks,
TJ
 
Top