Transferring row details from one sheet to another from an action

[THEJONLOPEZ]

I know excel basics and am trying to learn more advanced options. I am trying to figure out how to transfer row information from one sheet into another sheet with similar criteria. The sheets act as steps in a process for my department. Is this achievable? I also would like to know how to create a drop down box containing text that correlates what action the row should take. Once the action is selected the information from one row will be transferred to another sheet in the process system. Also if this is possible to do and still re-sort the sheets without compromising the code. If anyone could help i would be very grateful.

 

[My Aswer Is This]

You need to highlight the column you plan to put "Received" in then Choose Data from the Ribbon then choose "List" then enter Received in source.

Then no one will be allowed to enter any value other then "Received" in this column.


Then you need to tell me what need to happens when a person enters "Received" in that column on any row