I am looking for a VB code, searched online but nothing yet, that can do the following:

If “yes” is selected from Column M then look in Column F for which information is inserted then transfer the information to the right tab.

My column F has three selections from a validation List. The information that will be transferred will be decided on what selection the user will choose in column F.

The following code is inserted:

If Not Intersect(Target, Range("M:M")) Is Nothing Then
If Target.Cells.Count = 1 Then
If LCase(Target.Value) = "yes" Then

Range(Cells(Target.Row, 1), Cells(Target.Row, 9)).Copy
Sheets("Report").Cells(Rows.Count, "A").End(xlUp).Offset(1, 0).PasteSpecial xlPasteValues
Selection in Column F are A, B and C.

If A is selected then transfer the request to sheet “Report”
If B is selected then transfer the request to sheet “List”
If C is selected then transfer the request to sheet “Test”

I need to insert the above request. Is this possible?

Thank you so much...