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

Rackette

New Member
Joined
Jul 2, 2019
Messages
37
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.
 

Some videos you may like

Excel Facts

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.

Rackette

New Member
Joined
Jul 2, 2019
Messages
37
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.
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
40,791
Office Version
365
Platform
Windows
Are you looking in col A or col B for the values?
 

Rackette

New Member
Joined
Jul 2, 2019
Messages
37
Ummm....whooops. I see that I was asking about column B in my original post.
*face palm*
 

Rackette

New Member
Joined
Jul 2, 2019
Messages
37
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.
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
40,791
Office Version
365
Platform
Windows
You're welcome & thanks for the feedback
 

Watch MrExcel Video

Forum statistics

Threads
1,099,258
Messages
5,467,621
Members
406,545
Latest member
puneet829

This Week's Hot Topics

Top