Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Reconciling
I have a very large file that we have to reconcile monthly. There are two
worksheets, one is an A/P aged invoice and one has a list of all of our payments to vendors. I need to be able to match the vendor names from one column on each sheet and then match them to their corresponding invoice subtotals. If there is no match then we know to reconcile that account. Currently this process takes about 4 hours...on a good day. Anything that will help I would appreciate. Let me know if you need a sample of what I'm referring to. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Comparing and Reconciling 2 excel tables | Excel Discussion (Misc queries) | |||
Reconciling two lists | Excel Worksheet Functions | |||
creating a reconciling list of items not matched between two files | Excel Worksheet Functions | |||
Reconciling Data Ranges | Excel Discussion (Misc queries) |