Very new to excel. Hopefully I can explain what I am trying to accomplish. 
I added a photo of my screen. I am trying to make our timesheet at work more efficient. 
A17 has a dropdown list of employees. My goal is to be able to have all the info from row 17 duplicate if an employee is selected. 

So looking at my photo. If I have a work order number typed into cell E17 I would like that to be duplicated into cell E21 but only if there is an employee selected in dropdown cell A21 

Hopefully I explained it enough to understand what I am trying to accomplish. 

​Very new to excel. Hopefully I can explain what I am trying to accomplish. I added a photo of my screen. I am trying to make our timesheet at work more efficient. A17 has a dropdown list of employees. My goal is to be able to have all the info from row 17 duplicate if an employee is selected. So looking at my photo. If I have a work order number typed into cell E17 I would like that to be duplicated into cell E21 but only if there is an employee selected in dropdown cell A21 Hopefully I explained it enough to understand what I am trying to accomplish.     Read More

​