I want to be able to Enter Data straight down Column A, then hit CmdButtonRun, have it check
if Left(A:A,3) = "1Z8", then I want to move that cell to right in Column B,
if Left(A:A,3) = A numberic value less then "100" then move right x3 to Column D,
if Left(A:A,2) = "TO" then Don't move anywhere
Else
if Left(A:A, 3) = Anything other then others Move to right x2 in Column C
I know this is a lot, but I just need a little direction on how to get it to look at the column Range and to the Left Properties.
Appreciate any help