+ Reply to Thread
Results 1 to 1 of 1

Compare 2 columns from one tab to another and if found populate new tab

  1. #1
    Forum Contributor
    Join Date
    11-01-2012
    Location
    NJ
    MS-Off Ver
    Excel 365
    Posts
    109

    Compare 2 columns from one tab to another and if found populate new tab

    Hi

    This is an expansion on a previous post. I have working code that compares Column J on "GL Activity" and finds it in Column A on "Accruals". I need to do two more things. I need to compare Column G on "GL Activity" to Column C on "Accruals". So if both those conditions are met to insert the information.

    Before that happens though I want to scan through and make sure that all the entries that it would be inputting on the Accruals tab exists and if it doesn't exist, exit sub and show error message. Tab "Accruals Should Look Like" is what final product should look like. There is an example of error message on there as well in "D2:H4".

    Thank you for any assistance!

    Please Login or Register  to view this content.
    Attached Files Attached Files

+ 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. [SOLVED] Compare columns on one sheet to another and delete if negative values found
    By mikey3580 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 09-04-2019, 10:39 PM
  2. Need to compare values in 2 Columns & return result for what was found
    By pblobe in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-28-2015, 12:57 PM
  3. Compare Columns and Copy if match found
    By betsyroal in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-29-2014, 07:58 AM
  4. Compare 2 columns and remove duplicates in both columns when found
    By 1dtms in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-11-2013, 02:19 AM
  5. [SOLVED] Compare two columns with data, if match or not found then change the colour of cells
    By Sachy in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-15-2013, 03:58 AM
  6. Compare 2 columns then copy and paste the adjucent cell value if match is found
    By smartisenthil in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-01-2012, 12:11 PM

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