Hi all,

I am working on a spreadsheet for a fantasy hockey league (I know). I am going through the list of players and highlighting those that I’m interested in. I’m wondering if there is a function to send those highlighted to the sheet that contains their category? The players are all sorted on one mass list containing all positions, there are other sheets that break down players by position only (C, LW, RW, D, G). Is there a function that I can use to highlight players on the mass list which will also highlight them on their position specific sheet? Otherwise, is there a function that would send those players to a new sheet if I were to make one? I hope this is clear. I can link the sheet if need be. 

Thank you!

​Hi all, I am working on a spreadsheet for a fantasy hockey league (I know). I am going through the list of players and highlighting those that I’m interested in. I’m wondering if there is a function to send those highlighted to the sheet that contains their category? The players are all sorted on one mass list containing all positions, there are other sheets that break down players by position only (C, LW, RW, D, G). Is there a function that I can use to highlight players on the mass list which will also highlight them on their position specific sheet? Otherwise, is there a function that would send those players to a new sheet if I were to make one? I hope this is clear. I can link the sheet if need be.  Thank you!  Read More

​