Here I created a sheet for each support rep.
Create all the desired sheets in the workbook.(This feature is also available in prior versions of Excel.) Sound difficult? It’s not! The steps below explain how to set this up using Excel 2007 or later. Functions and charts analyzing data on any sheet should automatically adjust for new data.The master sheet can be sorted and filtered itself without affecting the subset sheets.New data added to the master sheet will automatically populate on the corresponding subset sheets.But in addition to that, I need the following to be possible: Now I want three separate sheets, one for each support rep in the Assigned To column, that will only contain that person’s support tickets.
