Forum Discussion
Sorting Staff into separate sections
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 li...
It depends would you like to edit data after it was copied or not. If not you may use FILTER() function. Or Power Query. With Power Query, using some tricks, you may also editable column, but if only you have unique ID in master sheet.
This is above my experience level, so these terms are way over my head. I guess I really need more training for Excel. Now I wonder which level would cover this?