Automatically send highlighted cells to another sheet

[pnyk27]

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!

[#2]

@pnyk27 

I can link the sheet if need be. 

Just as a rule of thumb, it is always helpful to link the sheet. If you are interested in solving it yourself with just a pointer or two, you don't need to, but if you want more specific help, it always helps us help you to see what you're actually working with.

That said, if you have a master database  with all those attributes identified, rather than highlighting via color, I'd suggest you just add a column for "Interest" or some such, enter a "Y" for those you are interested in (or numbers if you want gradations of interest). Then use the FILTER function to extract the rows to the sheets where you want them. Here's a video that explains FILTER; here's a website.