I am looking for a macro or formula from where i can reconcile data, the question is little complex to explain, however i will try and put in a way that can be understood
A dump is taken from the ERP (attached file)
What I am looking for
1. in the column "Desc" we have words like BKK Epay, Visa etc.,
2. Entries with text BKK" will have a date corresponding to it
3."BKK" will be postive amount
4. this have to be Reconciled with the entries which are "BI OP" which will be negative amount from the date of entry in BKK to - 7 days of "BI OP entries" dates for "BI OP" are in "Column A"
5. So if I have received 500 on Jan 7 2015 I would have corresponding entries for 500 (which could be -200,-100,-50,-50,-100) from Jan 1st to Jan 7th
6. the Same was "Epay+visa" will need to match up with "T BO"