I need a way to check one cell for a value and move the row

[omallyfoster]

I want to check and see if in cell A1 is there the letter "S" and if so then move the row of data to tab two. If A1 contains the letter "L" the row of data would go to tab three. If neither letters are present in the cell the row of data would go to tab four. Once as the first row is checked and the row is moved the program would go to the next row and start this process again until all rows have been checked and moved. Can anyone help I am new to this so I hope this makes sense.

Here is the thread I saw that works fro what I need but I can not understand this:
http://www.excelforum.com/excel-prog...new-sheet.html

[scott.s.fower]

Please Login or Register  to view this content.

[omallyfoster]

Wow I can not thank you enough this worked like a charm. I appreciate you help and I think this will save me today.