+ Reply to Thread
Results 1 to 6 of 6

Copy & paste of the data if matches

  1. #1
    Forum Contributor
    Join Date
    06-09-2014
    MS-Off Ver
    Microst Office 365 Plus
    Posts
    143

    Copy & paste of the data if matches

    Hi
    Plz see the attachments
    If column A of sheet1 matches with column B of sheet2 then copy column K data of sheet2 & paste it to column D of sheet1 & save the changes
    I need the macro of the same & Thnx for the Great Help
    Output after runing the macro is pasted in sheet3 plz have a look(Only for understanding pupose it is putted in sheet3)
    Attached Files Attached Files

  2. #2
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010
    Posts
    6,107

    Re: Copy & paste of the data if matches

    Try:
    Please Login or Register  to view this content.
    You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
    Practice makes perfect. I'm very far from perfect so I'm still practising.

  3. #3
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    15,258

    Re: Copy & paste of the data if matches

    Hi MB,

    Why don't you simply hide column A and E:J on your sheet 2 to get the same result? No VBA needed then.
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  4. #4
    Valued Forum Contributor
    Join Date
    11-04-2018
    Location
    Denpasar
    MS-Off Ver
    Excel 2010
    Posts
    576

    Re: Copy & paste of the data if matches

    Maybe something like this ?
    Please Login or Register  to view this content.
    I put the result in Sheet1 column E for checking.
    To put the result in column D, remove the comment sign (')
    Last edited by karmapala; 05-22-2020 at 11:06 AM.

  5. #5
    Forum Contributor
    Join Date
    06-09-2014
    MS-Off Ver
    Microst Office 365 Plus
    Posts
    143

    Re: Copy & paste of the data if matches

    Thnx Mumps & karmapala too... for providing the solution of this problem

  6. #6
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010
    Posts
    6,107

    Re: Copy & paste of the data if matches

    Glad to help.

+ 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] VBA Simple Check if 2 cells matches and if that is true it will copy and paste data .
    By Desotronics in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 05-10-2019, 01:04 PM
  2. Find matches, copy and paste adjacent cell
    By amein in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 05-23-2016, 11:21 AM
  3. [SOLVED] Trying to use Instr to copy all matches and paste to separate range
    By unit285 in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 01-06-2016, 10:57 AM
  4. Copy and paste row to worksheet that matches column name
    By Topper73 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-12-2013, 12:29 PM
  5. Macro to Copy & Paste when worksheet names matches
    By Arinp in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-30-2012, 06:54 PM
  6. Macro for WS/WB comparisons, and copy/paste two cells based on matches
    By adilley in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-13-2011, 10:46 PM
  7. Bug: Global Failure? Copy paste ontop if matches criteria
    By trillium in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-11-2011, 01:30 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