Need Help with complex formula
 

: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


--
TJF
------------------------------------------------------------------------
TJF's Profile: http://www.excelforum.com/member.php...o&userid=29096
View this thread: http://www.excelforum.com/showthread...hreadid=488170

Need Help with complex formula
 

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..

In article ,
TJF wrote:

: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.

Need Help with complex formula
 

Thanks for Helping.

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

Now I need to find a way to get that project managers commission to his
worksheet. The kicker is that it is not always the same project manager
assigned to the same salesman. I would like to know of a way for Excel
to check the names on the salesman worksheet then find the appropriate
project managers worksheet (by name) and then place in the appropriate
cell next to the name of the each salesman that the project manager has
worked for. i.e Mark is the salesman John is the PM and the program
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 next
to that.

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

Thanks,
TJF


--
TJF
------------------------------------------------------------------------
TJF's Profile: http://www.excelforum.com/member.php...o&userid=29096
View this thread: http://www.excelforum.com/showthread...hreadid=488170