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. #22
    Senior Member
    Join Date
    Jul 2019
    Posts
    382
    Rep Power
    0

    copy and paste by vba

    vba is placed in a seperate file macro.xlsm
    there are two files 1.xlsx & 2.xlsx
    all files are located in a different place
    2.xlsx file is blank file it doesn't have any data
    in 1.xlsx i have data (i have attached the sample pic of the same)
    now what i want is see the yellow highlighted colour data and if yellow highlighted colour data is greater than 5 or equal to 5 then copy the stock name and paste it to 2.xlsx
    i have attached the sample pic of the result it will be pasted to 2.xlsx from 1.xlsx
    so plz have a look sir and help me out in solving this problem sir
    Attached Images Attached Images

Similar Threads

  1. Replies: 48
    Last Post: 09-23-2020, 02:03 AM
  2. 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. Replies: 8
    Last Post: 10-31-2013, 12:38 AM
  5. Replies: 2
    Last Post: 09-18-2013, 12:30 AM

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
  •