Conditional move of row from sheet to sheet Office 2010

[shannyr]

Conditional move of row from sheet to sheet Office 2010

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​

 

[hiker95]

shannyr,

Welcome to the MrExcel forum.

What version of Excel are you using?

In worksheet Message Board:
1. are there title rows? If so, what row are they in?
2. what is the first row where you will be entering the C D I or A in column L?
3. are you manually entering the C D I A?
4. or are you using data validation in column L?
5. what is the last column of the data to move?

 

[shannyr]

Hiker

Retired Geek helped me on another forum. Thanks for the attempt. (the version was in the title)

Here is the solution: Conditional move of row from sheet to sheet | Windows Secrets Lounge

 

[hiker95]

shannyr,

Thanks for the feedback, and link to the other site.

You are very welcome.

Come back anytime.