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