Hi all, new member. Be gentle.
I'm creating a worksheet that will be used to list individual
transactions (300-400) daily. It will have few merchants (15-20) with
numerous individual transactions and changing fees ($15-$50).
The merchants will be entered via a dropdown menu I create.
Certain merchants will have a salesman associated with their
transactions that receives a percentage of their fee.
How do I create a table that basically says "if merchant is XYZ, enter
salesman name in B15, enter that salesman's commission formula in B16
(the formula would be a specified percent of the fee)"
My ultimate goal is to also have per merchant & per salesman summary
pages that have SUMIF statements that determine the final amount due to
each merchant & each salesman, possile combined with mail-merge info as
well.
I guestimate that I am an intermediate Excel user.
Thx for the help.
--
KaiWalk
------------------------------------------------------------------------
KaiWalk's Profile:
http://www.excelforum.com/member.php...o&userid=27815
View this thread:
http://www.excelforum.com/showthread...hreadid=473256