Let me start by saying the I am a novice when it comes to Excel. I know the basics and that is about it............
What I am looking to accomplish is to have a information in a row moved to a corresponding worksheet based on the information populated in a cells drop down. The only column that would have a drop down cell would be column the "Department" column. So for example, if I select from the drop down menu "Detailing", all information in that row would move to the "Detailing" sheet. If I selected "Programming", all information in the row would move to the "Programming" sheet. If I selected "Shop" all information in that row would move to the the "Shop" sheet. Thanks for any help that you can give.
What I am looking to accomplish is to have a information in a row moved to a corresponding worksheet based on the information populated in a cells drop down. The only column that would have a drop down cell would be column the "Department" column. So for example, if I select from the drop down menu "Detailing", all information in that row would move to the "Detailing" sheet. If I selected "Programming", all information in the row would move to the "Programming" sheet. If I selected "Shop" all information in that row would move to the the "Shop" sheet. Thanks for any help that you can give.