+ Reply to Thread
Results 1 to 1 of 1

Bank Reconciliation VBA Help

  1. #1
    Registered User
    Join Date
    06-11-2013
    Location
    UAE
    MS-Off Ver
    Excel 2003
    Posts
    1

    Bank Reconciliation VBA Help

    Hi,

    I need some help with automating a code for helping me doing bank reconciliation. I will mention it step wise.
    1. I will manually paste all data in column A, and second set of data in Column B.
    2. 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.
    3. 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
    4. 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.
    5. 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.
    6. 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.
    Last edited by showgun3; 06-12-2013 at 12:29 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1