reconciliation

After the reconciliation was complete, The range gives out as values in both worksheets, values only in first worksheet and values only in second worksheet. (see last portion) But my area of interest is values in both worksheets. See below. ABCDEF1dec2021CASHBOOKdec2021NBK502BOTH2AmountCount...

I was recently upgraded to Windows 10. When I run my macro in Excel (2016 MSO 64-bit) that is supposed to create an outlook email and attach files from a specific folder, only some of the emails generate now. If both of the Excel files noted in the code don't exist in the folder, Outlook no...

Hi everyone, I am currently working on a macro to apply a Vlookup on two different excel sheets. Actually, I wish to make sure that What is in sheet 1 is also in sheet 2. For this I have to make sure that for the same name the amount in the worksheet 1 is the same in work sheet 2. Example if...

I have 2 reports - one from "Sales", another from "Inventory". I want to develop a quick and easy way to reconcile them every day (i.e. macro would be ideal). Here's the data after my first macro - If you compare the 2 reports, you'll see that they don't match at first glance. That's...

I have seen this topic a lot recently but have not been able to apply the prior examples correctly for my scenario. I am working on a bank reconciliation tool, and need generating the table of mismatched or unreconciled values. Hopefully the following information will help explain. I have...

I was hoping to get some help on if there is a formula out there that has ability to help reconcile a specific value. I have a list of invoices and their respective dollar values. If a vendor lumps multiple invoices together into a check, is there a formula to help determine what invoices were...

Hi All, I have tried and tried to work my head around making lists of all unique permutations of a list of values that equal x but no luck. If any one has any idea I would apprecate it. Its like a brute force algorithm for passwords I guess but i cant work out how to only use each value once...

Hey guys, I am looking for a way to easily recon my bank statment by value. At the moment I generate a statment in CSV from the bank and compare it to transactions in my export. The layout is simple, the bank statment shows. <tbody> Date ID Value 2014-10-07 1254 $458.55...

Hi there. I have a long list of invoices and cash payments which I need to find the offseting entries. There are over 1,000 accounts and each account can have many entries, so over 20,000 lines of data, a long and laborious task which I have to do every week! The lady before me did this...

Hi, I data on a master document and have data sent in from various independent offices which I would like to reconcile. Each region along with the master is posted onto a separate worksheet in my spreadsheet but I would like to copy specific information in worksheet order and paste row by row...

Hi, I have a set of data like the below in sheet 1, i need to match the data by order number and show differences as exeptions on sheet 2 <TBODY> Order</SPAN> Purchase/Sale</SPAN> Currency</SPAN> CCY 1</SPAN> AMT 1</SPAN> CCY 2</SPAN> AMT 2</SPAN> Date 123</SPAN> P</SPAN> GBP/USD</SPAN>...

Dear All, I require to reconcile 2 sheets every month and its very tedious. Can this be automated by a macro. here is what I need to do. sheet 1 is the bank statement , sheet 2 is the reconciliation sheet, where I have to search the items from the sheet 1 and if the item is present in sheet 2...