Hi, I need a little more help with a macro.

1... In the code, after the copy of the row, I would like to clear th
contents of the row that the user selected in "1-OPEN" only of column
H:P.

2... I would like column A of the row in "1-OPEN" that the use
selected to change to "OPEN".

3.. I would like the user to end up in the sheet ("Did Not Meet Hirin
Criteria") in the row that was just pasted in and in column L of tha
row. (they will need to type in some text there..)

Here is the code as it stands.

Sub NotMeetCriteria()
ActiveCell.EntireRow.Copy Destination:= _
Sheets("Did Not Meet Hiring Criteria").Range("A"
Rows.Count).End(xlUp).Offset(1, 0)

End Sub

Help...thanks!
Mik

--
Message posted from http://www.ExcelForum.com