Results 1 to 10 of 29

Thread: copy and paste by VBA based on criteria

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 03-29-2020, 07:04 PM #11
    fixer
    fixer is offline
    Senior Member
    Join Date
    Jul 2019
    Posts
    382
    Rep Power
    0

    copy and paste by vba

    vba is placed in sample2.xlsm
    all files are located in a different places
    sheet name can be anything
    there are two files sample1.xlsx & sample2.xlsm
    match column B of sample1.xlsx matches with column A of sample2.xlsm
    if it matches then copy paste the data from column D to column H to sample2.xlsm from column B
    plz help me in solving this problem Sir
    plz see the result i have attached the pic of the same
    Attached Images Attached Images
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. Copy and Paste based on comparisons/Match and calculations of cells in two workbooks
    By fixer in forum Test Area
    Replies: 48
    Last Post: 09-23-2020, 02:03 AM
  2. Copy Paste based on comparisons calculations in 2 XL files, 1 might be .csv file .Opened in XL=Fail/Chaos
    By fixer in forum Test Area
    Replies: 85
    Last Post: 06-09-2020, 05:58 PM
  3. Copy paste data based on criteria
    By analyst in forum Excel Help
    Replies: 7
    Last Post: 01-13-2014, 12:46 PM
  4. VBA code to copy and paste row based on certain criteria
    By T0NT0 in forum Excel Help
    Replies: 8
    Last Post: 10-31-2013, 12:38 AM
  5. Copy data from 1 excel workbook to another based on certain criteria
    By Matt_M in forum Excel Help
    Replies: 2
    Last Post: 09-18-2013, 12:30 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
  •  

Forum Rules