Results 1 to 8 of 8

Loop Through 1 Range (Down a Column) and Find Values that Do NOT Exist in another Range?

Threaded View

  1. #1
    Registered User
    Join Date
    08-10-2011
    Location
    Cali
    MS-Off Ver
    Excel 365
    Posts
    63

    Loop Through 1 Range (Down a Column) and Find Values that Do NOT Exist in another Range?

    Bit stuck on this one (had been on a roll previously).

    We have some reports that require importing data into a new sheet within a workbook each month (that much is fine) and then comparing the rows against the previous month.

    Example sheet attached with very basic random generated data, but what I want to do is loop through the new worksheet (19-Jan) in column B and look at the value(s) in B (IF column A is a 4, but I can probably add that later). I then want to compare each value in column B (in a row with a 4 in column A) to the range in column B on Sheet 18-Dec (last month, and again if Column A has a 4 at the same row).

    This would be an If statement, with the idea being that if B4 (value=1200.01.) on sheet 19-Jan exists somewhere in the range of B4:B1570 on sheet 18-Dec, then you move on.

    If value in B4 (1200.01.) on Sheet 19-Jan does not exist in range B4:B1570 on Sheet 18-Dec, then it would do something (either store in a string, prompt a msgbox, etc). This is part I am stuck on as I haven't really moved past for and if statements with VBA into index/match/search/etc which I am assuming is what we are looking for. The value has to be an exact match, and the end game would be to get a list at the end of the loop with all values in the range on 19-Jan that DO NOT exist in the range on 18-Dec.

    Any help appreciated, I will keep plugging away.

    Thanks,
    Last edited by Norcal1; 01-30-2019 at 09:13 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Check if other strings exist in column based on range string values
    By jeroenft in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-12-2018, 11:47 AM
  2. [SOLVED] Check if other strings exist in column based on range string values
    By jeroenft in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-12-2018, 07:49 AM
  3. [SOLVED] Find and Replace Loop that looks up values in range for Search criteria
    By lougs7 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-06-2018, 04:31 PM
  4. Find text in range of cells and add to table if it does not exist in range
    By dgadler1 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-12-2013, 12:54 PM
  5. Replies: 3
    Last Post: 03-08-2012, 03:32 PM
  6. Macro Loop to Extract Specific Values and Min/Max Values From Column/Rows Range
    By ExcelQuestFL in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 12-19-2010, 09:19 AM
  7. Need to find specific values in range using loop
    By frk1980 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 01-10-2005, 10:52 PM

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