I want to move the entire row of data to a different sheet based on a condition in row L.
Example: 5 conditions exist:
Blank - row stays on main sheet (Message Board)
C - upon user entering/selecting "C" entire row moves from sheet Message Board to sheet COMPLETE
D - upon user entering/selecting "D" entire row moves from sheet Message Board to sheet DISQUALIFIED
I - upon user entering/selecting "I" entire row moves from sheet Message Board to sheet INQUIRY ONLY
A - upon user entering/selecting "A" entire row moves from sheet Message Board to sheet ABANDONED
I'd want to be sure this code or macro that is recommended does not execute every time it sees these letters in the spreadsheet - only executes when C D I or A appear in column L
Example: 5 conditions exist:
Blank - row stays on main sheet (Message Board)
C - upon user entering/selecting "C" entire row moves from sheet Message Board to sheet COMPLETE
D - upon user entering/selecting "D" entire row moves from sheet Message Board to sheet DISQUALIFIED
I - upon user entering/selecting "I" entire row moves from sheet Message Board to sheet INQUIRY ONLY
A - upon user entering/selecting "A" entire row moves from sheet Message Board to sheet ABANDONED
I'd want to be sure this code or macro that is recommended does not execute every time it sees these letters in the spreadsheet - only executes when C D I or A appear in column L