+ Reply to Thread
Results 1 to 8 of 8

Macro to copy and paste Data to another sheet when criteria is met

  1. #1
    Registered User
    Join Date
    02-29-2012
    Location
    Ireland
    MS-Off Ver
    Excel 2016
    Posts
    70

    Macro to copy and paste Data to another sheet when criteria is met

    Hi All

    I am trying to create a Macro that will transfer the Data in a row from Sheet1 to the next available row in Sheet 2 when "Yes" has been entered in Sheet 1 Column I.

    I have attached a sample document.

    Any help would be much appreciated.

    Thanks
    Attached Files Attached Files

  2. #2
    Forum Guru Sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2019 | 2021
    Posts
    14,958

    Re: Macro to copy and paste Data to another sheet when criteria is met

    Please Login or Register  to view this content.
    Good Luck...
    I don't presume to know what I am doing, however, just like you, I too started somewhere...
    One-day, One-problem at a time!!!
    If you feel I have helped, please click on the [★ Add Reputation] to left of post window...
    Also....Add a comment if you like!!!!
    And remember...Mark Thread as Solved...
    Excel Forum Rocks!!!

  3. #3
    Registered User
    Join Date
    02-29-2012
    Location
    Ireland
    MS-Off Ver
    Excel 2016
    Posts
    70

    Re: Macro to copy and paste Data to another sheet when criteria is met

    WOW!

    Works perfectly. Thank you so much for your help.

    Rep added.

    I love this place.

  4. #4
    Forum Guru Sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2019 | 2021
    Posts
    14,958

    Re: Macro to copy and paste Data to another sheet when criteria is met

    .........................
    THANKS.gif

  5. #5
    Registered User
    Join Date
    02-29-2012
    Location
    Ireland
    MS-Off Ver
    Excel 2016
    Posts
    70

    Re: Macro to copy and paste Data to another sheet when criteria is met

    Sorry pone last question before IO mark as solved. If I wanted to Cut the row instead of copying how would I do that? I tried changing the Copy to Cut and it worked but with a debug message at the end.

    Thanks again - very much appreciate it

  6. #6
    Forum Guru Sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2019 | 2021
    Posts
    14,958

    Re: Macro to copy and paste Data to another sheet when criteria is met

    Please Login or Register  to view this content.

  7. #7
    Registered User
    Join Date
    02-29-2012
    Location
    Ireland
    MS-Off Ver
    Excel 2016
    Posts
    70

    Re: Macro to copy and paste Data to another sheet when criteria is met

    Perfect thanks again

  8. #8
    Forum Guru Sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2019 | 2021
    Posts
    14,958

    Re: Macro to copy and paste Data to another sheet when criteria is met

    Anytime...Happy Coding...

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. VBA macro to copy/paste data from sheet to another depending on criteria
    By rishijain11 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-09-2019, 11:07 AM
  2. Macro: Copy/cut all rows matching criteria, and paste into specific Table/sheet
    By Andrewjs in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-10-2017, 03:55 PM
  3. Replies: 11
    Last Post: 05-12-2013, 11:30 AM
  4. [SOLVED] Copy and paste data from sheet 2 to sheet 1 based on specific criteria on sheet 1
    By VBADUD in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-05-2012, 04:18 AM
  5. Copy Paste cells into a new sheet based on criteria macro
    By Clessie1919 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-19-2012, 02:43 AM
  6. Copy Paste data with matching criteria from different sheet
    By Noor Hussain in forum Excel General
    Replies: 0
    Last Post: 06-14-2012, 01:23 AM
  7. [SOLVED] Macro to copy and paste rows to a new sheet based on criteria
    By Belo in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-31-2010, 02:25 AM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1