Results 1 to 2 of 2

Thread: Cut & paste between sheets Move Some Data Rows To New Worksheet Based On Conditions

Threaded View

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

    Cut & paste between sheets Move Some Data Rows To New Worksheet Based On Conditions

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

    macro will be placed in a macro.xlsm
    sample.xls & macro.xlsm both are loacted at different places, So the path should be hardcoded in the macro so that i can change it as per my needs
    sheet name can be anything

    If column D of sample.xls is equal to column E of sample.xls Or column D of sample.xls is equal to column F of sample.xls then do nothing else put that data into new sheet by creating a new sheet in it & remove that data from current sheet(plz see the sample file)




    https://www.excelforum.com/excel-pro...ml#post5368297
    http://www.eileenslounge.com/viewtopic.php?f=30&t=35000

    Attached Files Attached Files
    Last edited by DocAElstein; 07-27-2020 at 08:20 PM. Reason: another cross post..

Similar Threads

  1. Replies: 6
    Last Post: 08-28-2019, 09:42 AM
  2. Replies: 0
    Last Post: 09-26-2018, 02:37 PM
  3. Replies: 15
    Last Post: 01-04-2013, 03:26 PM
  4. VBA -- Copy/Paste across sheets
    By Rasm in forum Excel Help
    Replies: 4
    Last Post: 09-21-2012, 02:07 PM
  5. Trapping Copy To Range Before Copy/Cut Paste
    By Rasm in forum Excel Help
    Replies: 4
    Last Post: 04-07-2011, 07:48 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
  •