Hi,
I need some help with automating a code for helping me doing bank reconciliation. I will mention it step wise.
- I will manually paste all data in column A, and second set of data in Column B.
- Then I will run the macro, which will first sort all data in column A from small to large and then sort all data in column B from small to large.
- Next it will compare Cell A1 to B1, if they match it will print the difference which is a zero or a "-" in column c1
- If the two cells dont match, it check to see cell A1 < B1. If cell A1 is smaller then B1 then it will insert a new cell at b1 and push cell b1 down and print the difference in c1 which will be A1-0.
- But if B1 is greater then A1, then it will do an insert at cell A1 and insert a new cell at Cell A1 and push cell A1 down and put the difference in c1 which is 0-b1.
- Then a repeat until the end of data.
500 500 500 500 1000 1920 1920 2135.25 2135.25 3000 3000
after running the code, it should rearrange to look like:
500 500 - 500 500 - 1000 1000 1900 (1900) 1920 2135.25 2135.25 - 3000 3000 -
Hope I am specific.
Please assist in writing a vba code for the above problem. It will save me a lot of time.
Thanks.
Bookmarks