+ Reply to Thread
Results 1 to 2 of 2

Daily Reconciliation VBA

  1. #1
    Registered User
    Join Date
    12-04-2018
    Location
    Bucharest, Romania
    MS-Off Ver
    Office 365
    Posts
    1

    Daily Reconciliation VBA

    Hi,

    I am reconciling two sets of transactions in Sheet 1 and Sheet 2. And I wanted to be able to transfer those transactions that do not match to a new sheet.
    I need to match two columns in Sheet 1 and Sheet 2, one is the reference # and the other one is the transaction type.
    The columns in Sheet 1 are C and F and in Sheet 2 it's columns K and S.
    If everything matches, a message box will pop up and if there are non-matching transactions, it will create a Sheet 3 with the transactions from Sheet 1 and Sheet 2 that do not match.
    I have been reading in this forum for quite some time, but can't find a vba that matches what I need.


    Thanks,

    Crista

  2. #2
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010, 2013
    Posts
    7,777

    Re: Daily Reconciliation VBA

    When you say "match two columns", do you mean that the values in columns C and F have to match the values in columns K and S. In other words, both values have to match not just one. Is this correct? Do you want to add the values from Sheet1 that don't match the values in Sheet2? Do you also want to add the values from Sheet2 that don't match the values from Sheet1"? It would help to test possible solutions if you could attach a copy of your file. De-sensitize the data if necessary.
    You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
    Practice makes perfect. I'm very far from perfect so I'm still practising.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 07-09-2018, 11:57 AM
  2. Daily Allowance Calculation From Previous Daily Spending Against A Daily Budget
    By WillYoung351 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-03-2014, 05:00 PM
  3. Replies: 4
    Last Post: 02-01-2014, 10:37 PM
  4. Replies: 3
    Last Post: 10-01-2013, 05:05 AM
  5. Calculate daily targets given: month, monthly budget, daily indexes
    By Chuckyrp in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-06-2013, 03:30 AM
  6. [SOLVED] Daily Data Reconciliation
    By CRW in forum Access Tables & Databases
    Replies: 19
    Last Post: 09-15-2012, 02:35 AM
  7. Replies: 2
    Last Post: 01-09-2010, 04:06 AM

Tags for this Thread

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