Dear Experts,
i have a vision but that is already it - i found a few posts regarding similar problems and im sure this is possible to do - just don't know how
im looking for a macro to reconcile transactions netting to zero. daily i get a predefined output file containing necessary infromation like portfolio, account type, currency and amount - all other columns are irrelevant - i attached a sample . This file is usually between 800 and 1500 records and probably 30% could be matched - this is what im after. There are very few 1:1 amount matches, great majority is the sum of several amounts netting off - Usually there are 5-15 trx by account/type/currency combination, rarely there is one with 20-25 items.
My goal is to identify all matches (zero or with little tolerance) within each account/type/currency combination (in column A) - If a match is found it should mark it as "match" (preferably in column N), if not it should move on to the next account until finished. - would be nice it would be finished within one hour.
i really appreciate if someone could help me with a smart and simple solution
many thanks in advance
gignz
Bookmarks