Results 1 to 3 of 3

Thread: Copy row from one workbook to another workbook based on conditions in two other workbooks

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Senior Member
    Join Date
    Jul 2019
    Posts
    382
    Rep Power
    0

    Copy row from one workbook to another workbook based on conditions in two other workbooks

    Hi,
    I am looking for a macro that will do the things mentioned below

    If coloumn I of 1.xls matches with column Z of ap.xls & column K of ap.xls is equals to column L of ap.xls Then
    Look column H of 1.xls & if column H of 1.xls is greater than column D of 1.xls then it has to copy the first row of OrderFormat.xlsx & pate it to BasketOrder.xlsx (in sheet1 & sheet1 name can be anything)

    Or

    If coloumn I of 1.xls matches with column Z of ap.xls & column K of ap.xls is equals to column L of ap.xls Then
    Look column H of 1.xls & if column H of 1.xls is lower than column D of 1.xls then it has to copy the third row of OrderFormat.xlsx & pate it to BasketOrder.xlsx (in sheet1 & sheet1 name can be anything)

    The output of the macro will be in BasketOrder.xlsx (I have mentioned the result plz see)

    Thnx For the Help
    Attached Files Attached Files

Similar Threads

  1. Replies: 101
    Last Post: 06-11-2020, 02:01 PM
  2. Replies: 4
    Last Post: 04-10-2014, 10:58 PM
  3. Replies: 2
    Last Post: 09-18-2013, 12:30 AM
  4. Save Worksheets As Seperate Workbooks Based On Conditions
    By jffryjsphbyn in forum Excel Help
    Replies: 4
    Last Post: 07-17-2013, 07:15 AM
  5. Replies: 2
    Last Post: 05-28-2013, 05:32 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •