Page 2 of 2 FirstFirst 12
Results 11 to 17 of 17

Thread: If cell value = something, then cut row and paste to next sheet
Thanks Thanks: 0 Likes Likes: 0

  1. #11
    New Member
    Join Date
    Jul 2019
    Posts
    37
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: If cell value = something, then cut row and paste to next sheet

    I have a header in row one on Sheet1 and on Sheet2. Both sheets are in the same workbook. If it matters, my headers are: ID, Name, Number, Start time, End Time, Location, Reason, Mandatory.
    Column A will always have an ID in it. The ID will always be in a format of 6E074L. There may or may not be data in all of the cells on the row. For instance, the "Reason" column may be empty for some rows.

  2. #12
    New Member
    Join Date
    Jul 2019
    Posts
    37
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: If cell value = something, then cut row and paste to next sheet

    I have headers in row 1 of Sheet1 and of Sheet2. If it matters, my headers are: ID, Name, Number, start time, end time, location, reason, mandatory.
    I am using Office 365.
    Column A will always have data in it in the format of 6E043L. Not all cells in a row will contain data. For example, there may be nothing in Reason nor in Mandatory.

  3. #13
    MrExcel MVP
    Moderator
    Fluff's Avatar
    Join Date
    Jun 2014
    Location
    Chippenham
    Posts
    28,177
    Post Thanks / Like
    Mentioned
    470 Post(s)
    Tagged
    47 Thread(s)

    Default Re: If cell value = something, then cut row and paste to next sheet

    Are you looking in col A or col B for the values?
    - Posting Data try one of these tools
    - Posting guidelines, forum rules and terms of use
    - Read the FAQs

    Running Office 365 on Win 10

  4. #14
    New Member
    Join Date
    Jul 2019
    Posts
    37
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: If cell value = something, then cut row and paste to next sheet

    Column A.

  5. #15
    New Member
    Join Date
    Jul 2019
    Posts
    37
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: If cell value = something, then cut row and paste to next sheet

    Ummm....whooops. I see that I was asking about column B in my original post.
    *face palm*

  6. #16
    New Member
    Join Date
    Jul 2019
    Posts
    37
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: If cell value = something, then cut row and paste to next sheet

    Fluff, yours works just fine.
    Irobbo, I'm not sure if yours will work, because I'm not sure what I need to change to make it look at column 1 instead of column 2.

    Thank you! I'm very sorry about my mistake that managed to waste your time.

  7. #17
    MrExcel MVP
    Moderator
    Fluff's Avatar
    Join Date
    Jun 2014
    Location
    Chippenham
    Posts
    28,177
    Post Thanks / Like
    Mentioned
    470 Post(s)
    Tagged
    47 Thread(s)

    Default Re: If cell value = something, then cut row and paste to next sheet

    You're welcome & thanks for the feedback
    - Posting Data try one of these tools
    - Posting guidelines, forum rules and terms of use
    - Read the FAQs

    Running Office 365 on Win 10

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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