I am trying to accomplish the following in Excel:

Sub Correct_Rows()
if B2 = 16210 Then
Cut cells B2:V2
Move Up 1 Row
Move Over 4 Columns
Past cells
Delete Row 2
ElseIf B2 = "PO" Then
Delete Row 2
End If

Scroll thru rest of rows in Column B and repeat.

End Sub

The size of the worksheet will vary each time the macro is run, so it
must be dynamic. Column B will always be the column checked and the cut
and paste will always be "cut n, paste n-1, four columns over.

See? I have been trying desperately to build this and CANNOT figure out
how to use the debug (or any of the tools). I just assume that when it's
right, it will do what i need.

Any help is greatly appreciated!!


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!