Working in Windows 10 Microsoft Office 365 Excel.
I have a Master list of Staff members who each work in different sections. I have sheets for the different sections in the same workbook. I would like to automatically add members from the Master sheet to the appropriate section sheet so that I can have a list of staff in each section. or vice versa. This can be referenced by specific text in a certain column. But I want the whole line of data copied to the corresponding sheet. I would mostly like to initially enter the data on the Master sheet, but would need to change the section of the staff member on an occasional basis.
