I need to copy a row to another sheet in the same workbook based on a drop down answer.

[Mebillups]

i need to copy a row to another sheet in the same work book based on the drop down selection chosen. Column A is drop down with possible selections of Tile, Stone, Marble. Based on the selection the row gets copied to the next available row on the sheet with the same title.

1st sheet is a log for all invitations to bid work. Based on the selection in the drop down the data copies to another sheet with the correct title. If tile is selected it gets copied to the sheet with all the tile projects etc

 

[Fluff]

Hi & welcome to MrExcel.
How about

Private Sub Worksheet_Change(ByVal Target As Range)
   If Target.CountLarge > 1 Then Exit Sub
   If Target.Column = 1 And Target <> "" Then
      Target.EntireRow.Copy Sheets(Target).Range("A" & Rows.Count).End(xlUp).Offset(1)
   End If
End Sub

This needs to go in the Log sheets code module.