Drop down list selection causes row to be copied and pasted to another sheet

karimarie

New Member
Joined
Jun 1, 2018
Messages
2
I have an excel file that when I select "consultant" under "To be processed by" I want the rows values from Date to Status to be copied to another sheet. Sheet 1 called "Requests" and Sheet 2 is called "Consultant". I only need this to be for the consultant selection. I may be excel challenged so I need simple instructions. Please ask for clarification if needed
DateTypeRequestedDept.THLocatAssignStatusTo Be Processed By
*I am drop down LIST with four options

<tbody>
</tbody>
 

Some videos you may like

Excel Facts

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
46,134
Office Version
  1. 365
Platform
  1. Windows
Hi & welcome to MrExcel
How about
Code:
Private Sub Worksheet_Change(ByVal Target As Range)
   If Target.CountLarge > 1 Then Exit Sub
   If Not Target.Column = 9 Then Exit Sub
   If LCase(Target.Value) = "consultant" Then
      Range("A" & Target.Row).Resize(, 8).Copy Sheets("Consultant").Range("A" & Rows.Count).End(xlUp).Offset(1)
   End If
End Sub
To install this right click on the tab you want this to work on > view code > paste the code into the window that opens up.
Save the file as an xlsm file.
Then whenever you enter consultant into col I that row will be copied to a sheet called Consultant
 

karimarie

New Member
Joined
Jun 1, 2018
Messages
2
Thank YOU! I had been searching through codes all morning with no luck! This worked perfectly!
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
46,134
Office Version
  1. 365
Platform
  1. Windows
Glad to help & thanks for the feedback
 

Watch MrExcel Video

Forum statistics

Threads
1,108,728
Messages
5,524,484
Members
409,584
Latest member
RedHelp

This Week's Hot Topics

Top