I am creating a workbook where sheet 1 will be a master list with each row on sheet 1 being a project. With in the project there is a dropdown list to assign someone as the "owner" of the project. Each owner will have a tab(sheet) in this work book.
What I want is when I select the owner from the dropdown for each project, excel will copy the info on that row and paste it onto the next available row on the tab(sheet) corresponding to the specific owner selected in the drop down box.
Please let me know if this makes no sense at all.
Bookmarks