+ Reply to Thread
Results 1 to 7 of 7

vba import missing values and paste as values

  1. #1
    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

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,811

    Re: vba import missing values and paste as values

    Try this:

    Please Login or Register  to view this content.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Registered User
    Join Date
    12-11-2014
    Location
    New York
    MS-Off Ver
    office 2010
    Posts
    71

    Re: vba import missing values and paste as values

    seems to be working great only thing is that its pasting with formating and I would like it to paste only values dont want to copy color highlights and boarder formatting

  4. #4
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,811

    Re: vba import missing values and paste as values

    Modified to paste values



    Please Login or Register  to view this content.
    Last edited by alansidman; 05-22-2017 at 05:41 PM.

  5. #5
    Registered User
    Join Date
    12-11-2014
    Location
    New York
    MS-Off Ver
    office 2010
    Posts
    71

    Re: vba import missing values and paste as values

    its only pasting C column values not everything else now

  6. #6
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,811

    Re: vba import missing values and paste as values

    Apologies. Had a typo in the code. Misspelled Special. I have fixed it. Try the code now.

  7. #7
    Registered User
    Join Date
    12-11-2014
    Location
    New York
    MS-Off Ver
    office 2010
    Posts
    71

    Re: vba import missing values and paste as values

    works perfect thanks

+ 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] 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. Replies: 1
    Last Post: 12-19-2014, 06:38 AM
  3. 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. [SOLVED] 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. 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1