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...
Bookmarks