I am currently trying to update a couple workbooks and would like to
combine them into one workbook with multiple sheet.

What I have:
One sheet is a proposal sheet and I have four other sheets that depend
on what the average ticket is of the proposal as to which commission
calculators I use. What I would like to happen is that when the average
ticket on the proposal sheet is u <15.00 I would like all the proceeding
information about that proposal to go into the <15.00 average ticket
commission calculator. I would like for this to happen for a range of
average tickets that include <15, 15-25 and 25.00.

I hope this is possible at it would cut out many mistakes on my sales
team from them using the wrong commission calculator.

Thanks is advance,
JD


--
jdeer0618
------------------------------------------------------------------------
jdeer0618's Profile: http://www.excelforum.com/member.php...o&userid=34553
View this thread: http://www.excelforum.com/showthread...hreadid=543177