I have a New Hire tracking spreadsheet that I would like to have move and/or copy data from one row in one sheet to another sheet based on selection from a drop-down.
For example: Sally Newhire starts with our company and within 2 months, resigns. I would like to be able to select "Resigned" next to her name and have her row of data show up on the "Resigned" sheet in the same workbook. I would also like for this data to "move" if I change the selection in the drop-down (i.e., if the option goes from "Week 1" to "In Cohort," I no longer want the data to show up on the "Week 1" sheet).
Options for the Drop-down would include: Week 1, In Cohort, Needs Makeup Cohort, Cohort Completed, Intern, No Cohort Needed, Resigned.
I hope this makes sense. Thank you for any assistance!
For example: Sally Newhire starts with our company and within 2 months, resigns. I would like to be able to select "Resigned" next to her name and have her row of data show up on the "Resigned" sheet in the same workbook. I would also like for this data to "move" if I change the selection in the drop-down (i.e., if the option goes from "Week 1" to "In Cohort," I no longer want the data to show up on the "Week 1" sheet).
Options for the Drop-down would include: Week 1, In Cohort, Needs Makeup Cohort, Cohort Completed, Intern, No Cohort Needed, Resigned.
I hope this makes sense. Thank you for any assistance!