I'm completely new to VBA, so I hope this makes sense! I have a master page with all my data on it called "client list". I want to extract data from this master list and move it to other sheets. I want to run a macro that says "if a line of data has Sally's name under the 'allocation' column (column M), and there is no 'discharge date' (column V), then copy to the sheet called Sally, but if there's no name in the 'allocation' column, then use the data in the 'assessment' column (column H), and if the name in the assessment column in 'sally', then copy to the sheet called Sally". Hope this makes sense!!!! So far I have the below, but it's not working 
Dim i, LastRow
LastRow = Sheets("client list").Range("A" & Rows.Count).End(xlUp).Row
Sheets("Sally").Range("A2:Z1000").Clear
For i = 2 To LastRow
If Sheets("client list").Cells(i, "M").Value = "Sally" And Sheets("client list").Cells(i, "V").Value = "" Then
Sheets("client list").Cells(i, "M").EntireRow.Copy Destination:=Sheets("Sally").Range("A" & Rows.Count).End(xlUp).Offset(1)
Next i
For i = 2 To LastRow
Else
If Sheets("client list").Cells(i, "M" And "V").Value = "" And Sheets("client list").Cells(i, "H").Value = "Sally" Then
Sheets("client list").Cells(i, "M").EntireRow.Copy Destination:=Sheets("Sally").Range("A" & Rows.Count).End(xlUp).Offset(1)
End If
Next i
Bookmarks