Hello! Newbie alert. Ive been trying to create a spreadsheet that allows us to track enquiries through to proposals and then live projects.
See attached spreadsheet for the basics.
In short, i'd like to move the information in one row to another sheet once a specific dropdown value is selected., Ive seen loads of examples of this but for some reason i cant seem to get it to work on my spreadsheet.
I have 5 worksheets as follows
Enquiries
Proposals
Live Projects
Closed Projects
Rejected
I want to be able to move rows from one sheet to another by selecting the relevant choice in a dropdown. My dropdown choices are as follows:
Enquiry Open
Enquiry Rejected
Proposal Sent
Proposal Rejected
Project Live
Project Closed
I've tried the following:
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 10 Then
If Target = "Enquiry Rejected" Then
Application.EnableEvents = False
nxtRow = Sheets("Rejected").Range("I" & Rows.Count).End(xlUp).Row + 1
Target.EntireRow.Copy _
Destination:=Sheets("Rejected").Range("A" & nxtRow)
Target.EntireRow.Delete
End If
End If
Application.EnableEvents = True
End Sub
But im not getting any joy.
Can anyone help with this? It's doing my head in!
Bookmarks