Jan 25, 2021
Sorting Throughout Multiple Sheets Issue
The first sheet I have a list of all the salespeople along with their sales for each month and a total of YTD sales in a column.
Then I have monthly sheets with a summary of the MTD Sales.
Then I have weekly sheets with each individual sale by person and date.
Each person has their own row.
I referenced the first sheet in the other sheets to keep the names updated as we hire. But when I add a new person on the first sheet and sort the column to put it in alphabetical order, it sorts in the other sheets but then the rest of the row in those sheets do not sort with it. It does in the first sheet, but not the rest. I need each writer to stay with their row of information in each sheet no matter how I sort them in the first sheet. Is this possible or is there a better way to do this?
I also would like to rank each salesperson based on their total sales. Not quite sure how to do that and keep them from moving with the rest of the information.
I have attached the link to the sheet for reference.
Community content may not be verified or up-to-date. Learn more.
Last edited Jan 26, 2021
All Replies (7)