I have a master list of customers to whom I pay a certain percentage of
commision which I specify. Each month I receive reports of the
commisions my customers have generated but each month is different,
sometimes some customers appear and others don't. Is there a way where
I can use a master list which identifies which customers receive what
percentage and have excel automatically enter this percentage next to
their name when their names appear in my reports? Right now I am
copying and pasting the info I receive from the reports and entering by
hand the percentage each will receive by checking my master list.
Thanks.


--
Billznik
------------------------------------------------------------------------
Billznik's Profile: http://www.excelforum.com/member.php...o&userid=37119
View this thread: http://www.excelforum.com/showthread...hreadid=568499