Results 1 to 10 of 86

Thread: Copy Paste based on comparisons calculations in 2 XL files, 1 might be .csv file .Opened in XL=Fail/Chaos

Threaded View

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

    Copy and paste the data if condition met

    All files are located in different path
    vba will be placed in a macro.xlsm
    i have a file name 1.xls & 2.xls
    match column I of 1.xls with column B of 2.xls
    If column I of 1.xls matches with column B of 2.xls then do nothing &
    if column I of 1.xls doesnt matches with column B of 2.xls then copy and paste the column B & Column I of 1.xls to column A & column B of sheet2 of 2.xls
    sheet name can be anything
    plz see the sample pic & help me in solving this problem by vba

    the bigger pic is 1.xls
    the smallest pic is sheet2 of 2.xls (result)



    Moderator notice...
    Yet again another cross post
    https://www.excelguru.ca/forums/show...-condition-met
    Attached Images Attached Images
    Last edited by DocAElstein; 05-30-2020 at 03:21 PM. Reason: Yet another cross post
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. VBA Dir File Copy and Paste: Check if file exists then copy file from one directory to another. Bat File
    By fixer in forum Test Area
    Replies: 26
    Last Post: 09-26-2020, 05:56 PM
  2. Copy paste data based on criteria
    By analyst in forum Excel Help
    Replies: 7
    Last Post: 01-13-2014, 12:46 PM
  3. 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
  4. 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