Results 1 to 7 of 7

vba import missing values and paste as values

Threaded View

  1. 05-22-2017, 01:11 PM #1
    izk630
    izk630 is offline
    Registered User
    Join Date
    12-11-2014
    Location
    New York
    MS-Off Ver
    office 2010
    Posts
    71

    vba import missing values and paste as values

    I would like my sheet to check on sheet 2 any doc# (column C) thats not already listed on sheet 1 and copy and paste as values the missing doc# into sheet 1 as well as all columns that match (from colum c to p on sheet 1)

    the reason I am not just using an index match is because my sheet 2 is an external source that keeps changing data and past data gets erased when the new one is imported

    attaching example sheet.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Import data to workbook - Paste values
    By BPSJACK in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-10-2015, 08:03 AM
  2. Error with PivotTable Dropdown List - Jumbled up, Values Missing and Blank Values
    By arspacio in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 12-19-2014, 06:38 AM
  3. Using Vlookup or similar function to find missing values compared to base values
    By kkxm in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-30-2014, 05:49 PM
  4. Copy Paste the Missing Values in a Specified Cells and Insert the Rows into a Report
    By judeprem in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-30-2013, 01:46 PM
  5. Find missing values - based on looking up a list, comparing against index values
    By anakaine in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 01-22-2013, 01:31 AM
  6. Comparing values in two columns and displaying missing values in n
    By cpetta in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-04-2005, 11:29 PM
  7. Excel Compare values in columns & display missing values in a new
    By cpetta in forum Excel General
    Replies: 1
    Last Post: 04-02-2005, 01:06 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1