I have a workbook with a master sheet and 3 subsheets (Brittany, Cleve and Scott). I have several columns labeled Date, Catalog Number, Action Requested, Assigned, Completion Date and Notes.
When a name is entered in the assigned field on the Master I need the entire line of data associated with the that name to be moved to the sheet with that name.
Bookmarks