Macro for Reconciling Intercompany GL Activity

Hello,

I am looking for code to try and clear as many items within a GL that net to zero. Some may be a one to one match where others could be a 2 to 1 match or possibly even a 10 to 1 match or more so that the only amounts remaining are items that do not net to zero. Attached is an example of activity. Any help would be appreciated. I have found a lot of code but most of it is not working the way I had hoped. I have another file with code as well but you have to run through each scenario and delete rows after each macro is run before running the next.

if you would like to see the other file with the multiple steps let me know and I can post

If I filter the data based on GL column, you only have 5 rows with zero values.

Sorry I am not sure I understand your post. There are a number of rows that have a one to one match netting to zero. There are some afterwards that net 2 items to 1 netting to zero. There may be months where it can find 10 values or more that net against one value.

Amartin
If you are referring to my post, you are probably right, I do not.