+ Reply to Thread
Results 1 to 4 of 4

Cut row and copy same sheet if value is meet

  1. 09-10-2021, 02:20 PM #1
    Gazou is offline
    Registered User
    Join Date
    04-22-2014
    Location
    Canada
    MS-Off Ver
    Office 365
    Posts
    43

    Cut row and copy same sheet if value is meet

    Good afternoon,

    I am looking for a macro that will search a specific column and if value is meet then cut row and copy it 1 cell to the right.

    So needs to search for "Yes" in Column C if so then cut row from C and paste in Column D same row.

    A B C D E F G
    1 Women No No Extra Extra Extra
    2 Men Yes Extra Extra Extra
    3 Child No No Extra Extra Extra
    4 Kid No No Extra Extra Extra

    Appreciate any help or suggestions
    Thanks
    Last edited by Gazou; 09-13-2021 at 08:54 AM.
    Reply With QuoteRegister To Reply
  2. 09-10-2021, 08:24 PM #2
    Croweater is offline
    Spammer
    Join Date
    10-23-2012
    Location
    Adelaide, Australia
    MS-Off Ver
    Excel 2003, Office 365
    Posts
    1,237

    Re: Cut row and copy same sheet if value is meet

    like this?
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  3. 09-13-2021, 08:55 AM #3
    Gazou is offline
    Registered User
    Join Date
    04-22-2014
    Location
    Canada
    MS-Off Ver
    Office 365
    Posts
    43

    Re: Cut row and copy same sheet if value is meet

    works like a charm

    A big thank you!
    Reply With QuoteRegister To Reply
  4. 09-13-2021, 08:58 AM #4
    Croweater is offline
    Spammer
    Join Date
    10-23-2012
    Location
    Adelaide, Australia
    MS-Off Ver
    Excel 2003, Office 365
    Posts
    1,237

    Re: Cut row and copy same sheet if value is meet

    No problems at all.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. list (parts of) a sheet in another sheet if it meet criteria
    By nd2828 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 03-28-2017, 06:26 AM
  2. Copy rows of data that meet date range criteria to new sheet
    By natik in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-16-2015, 09:58 PM
  3. Copy rows that meet conditions from one sheet to another sheet
    By nilamani in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-27-2014, 05:00 PM
  4. Macro to Copy Values from another Sheet and insert certain # of rows if condition is meet
    By roje in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-11-2013, 02:58 AM
  5. copy row to another sheet if criteria is meet
    By roje in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 04-27-2013, 12:15 AM
  6. HELP - DEADLINE TO MEET - NEWBIE - FAIRLY EASY ONE (Auto Copy Data from Sheet to Sheet)
    By laforce in forum Excel General
    Replies: 3
    Last Post: 04-23-2013, 06:49 PM
  7. Copy all row's of data across all sheets, that meet certain criteria, to one sheet.
    By r0bd in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-05-2012, 01:21 PM

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


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1