|Thank you to every one that helped in my previous post. I did not get the exact answer to my queries but it helped massively.|
Now i have manage the get half of the asnwer to my queries by joggling through the various replies from your expertise.
Here is what i came up with:
Private Sub Worksheet_Change(ByVal Target As Range)
Application.EnableEvents = False
If Target.Column = 5 Then
If Target = "Y" Then
'If yes, Store Row number, Determine next empty Row in
delRow = Target.Row
nxtRow = Sheets("Removed List").Range("A" & Rows.Count).End(xlUp).Row + 1
Target.EntireRow.Cut Destination:=Sheets("Removed List").Range("A" & nxtRow)
Application.EnableEvents = True
Now, i am trying to use more than one selection instead of only one which, is the Y:
I would like to use "Y" or "W" to move the row. But currently, when i select Y the row is moved to the destination sheet but i tried all i could think of but my second selection is not working. Your help will be much appreciated.