Hi Excel Experts
I have service orders that generate revenue every month. The activation commissions is paid on these orders only the first month the order is activated and correct sales info is available. Otherwise, the commissions are delayed until the correct info is available. The orders each quarter can be the existing or the newly activated orders.
I want to pay commission for the existing and new orders generating revenue this quarter:
1. Check all existing orders that were not paid activation commission earlier and flag these for payment of commission if the correct info is now available.
2. For all the new orders activated this quarter, flag the orders that should be paid commission. So if an order was activated in April then set the flag to 1 for April and set it to 0 for May and June since the activation commission is paid only for one month.
Flag = 1 Pay commission
Flag = 0 Do not pay commission
The first step I can do with vlookup and mark the old orders for payment of commission if not paid earlier. The 2nd step for flagging new orders only the first month challenges me. How do I set the flag for the first month and ignore the other months in the quarter,
Appreciate any help.
Regards
Sales
Posted by: mehmud@yahoo.com
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (1) |
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.
----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA
----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com
----------------------------------
Tidak ada komentar:
Posting Komentar