+ Reply to Thread
Results 1 to 3 of 3

Add value not found to existing list.

  1. #1
    Registered User
    Join Date
    06-11-2014
    Posts
    1

    Add value not found to existing list.

    I have two spreadsheets that use a Number as a Key. I need to compare the numbers on list 1 to the numbers on list 2 and add any values that exist on list 1 but not on list 2 to the end of list 2. List 1 is in Column B, List 2 in in column C of a different sheet in the same workbook. Help?

  2. #2
    Valued Forum Contributor
    Join Date
    08-06-2013
    Location
    Detroit, Michigan
    MS-Off Ver
    Excel 2013
    Posts
    671

    Re: Add value not found to existing list.

    Try this
    Please Login or Register  to view this content.
    1. Include a sample workbook with an example of the result you want
    2. Use [CODE] and [FORMULA] wrappers for your VBA code or excel formulas
    3. If your question has been answered, mark the thread as SOLVED and click on the "Add Rep" star to thank whoever helped you.

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,933

    Re: Add value not found to existing list.

    I think this belongs in the Excel forum, not Outlook Formatting & Functions?

    I will move it for you
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ 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. Populate data in existing column if matching found using macro
    By abraham30 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-24-2014, 03:52 AM
  2. Check for values in a table and if found add value found in column to left to list
    By robhargreaves in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 08-07-2013, 02:57 PM
  3. update existing value of the record found...
    By djmag in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-16-2013, 12:43 AM
  4. [SOLVED] Select Existing WS from Range List + Copy + Rename from List
    By robegan in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-06-2013, 10:56 PM
  5. Existing macro not found
    By MattEfb in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-31-2008, 08:00 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