| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to match debit and credit line item
Dear sir / Mam
I need help form you how to matching debit an credit line itmes with help of macro we have thousand line items for example below. Once the line item will matched those line item will come in a seperate sheet pls help me in this regards Number Type Document Amount Profit Center 290001792005 JA 29000179 1,105,837.60 251490 290001802005 JA 29000180 1,171,001.00 251490 290001832005 JA 29000183 -1,105,837.60 251490 290001792005 JA 29000201 -1,105,837.60 251490 290001802005 JA 29000202 -1,171,001.00 251490 290001832005 JA 29000205 1,105,837.60 251490 290001302006 JA 29000130 1,622,723.00 251490 290001302006 JA 29000149 -1,622,723.00 251490 The above is the example can you please write the macro and reply to me immediately EggHeadCafe - Software Developer Portal of Choice EggHeadCafe Lets Visitors Slap Microsoft http://www.eggheadcafe.com/tutorials...-visitors.aspx |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i set up a debit and credit formula on the worksheet | Excel Worksheet Functions | |||
| I need help with cell returning number as credit or debit | Excel Programming | |||
| Debit/credit amount Slection How? | Excel Discussion (Misc queries) | |||
| Credit and Debit formating | Excel Discussion (Misc queries) | |||
Threaded Mode
