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
<tbody>
</tbody>
Date | Type | Requested | Dept. | TH | Locat | Assign | Status | To Be Processed By |
*I am drop down LIST with four options |
<tbody>
</tbody>