+ Reply to Thread
Results 1 to 2 of 2

Copy range to another Workbook if values are found (matched)

  1. #1
    Registered User
    Join Date
    09-07-2021
    Location
    Vilnius
    MS-Off Ver
    2020
    Posts
    1

    Exclamation Copy range to another Workbook if values are found (matched)

    Hello gurus,
    Here it is in short:
    What I need is the code to
    1.Go through column A in Workbook1 find matches in Workbook2.
    2.Copy Columns A (overwrite), B and C from Workbook1 to matching data in Workbook2

    Meaning: Find the same A value in another workbook and paste A:B to it.

    Thanks!!! I learned a lot from you guys here <3
    Untitled.png
    Last edited by JovanAndelkovic; 01-09-2022 at 08:47 AM. Reason: Adding Attachments

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,482

    Re: Copy range to another Workbook if values are found (matched)

    Please read the yellow banner at the top of this page on how to attach a sample workbook.

+ 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. Replies: 0
    Last Post: 05-05-2021, 10:08 AM
  2. [SOLVED] VBA:Copy and Paste Entire Row of specific Part Number if it is matched into a New Workbook
    By tamprint in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 04-23-2018, 04:00 AM
  3. [SOLVED] Copy columns to new workbook with matched headers, then save new workbook as a text file.
    By haitran in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-17-2017, 05:53 PM
  4. Copy columns to a new workbook if the headers row matched
    By haitran in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 12-13-2017, 06:32 PM
  5. [SOLVED] How to copy a range of matched value to another worksheet
    By caooi23 in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 10-07-2015, 08:33 PM
  6. Search cell values from range in another workbook and copy found row to a 3rd workbook.
    By SierraKilo78 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-09-2014, 01:09 PM
  7. Search a range and copy data if matched
    By Steven811 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 06-14-2012, 10:22 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