Mirroring cell data from a Sort Column on a Different Sheet

Question

Good day,

I am running a basketball tournament with multiple grade level divisions. I have a sheet that contains the master schedule for the entire tournament and then sheets for each grade level division.

On the master schedule, if I sort out the 5th grade boys division (for example), it will only show the games for that division.

What I am trying to do is mirror the cells in the master sheet to the grade level sheets so I only have to record the scores once on the master sheet and it will automatically put in the scores of each game on the grade level sheet.

However, when I sort (for example) the 5th grade boys games ONLY on the master sheet...the cells that I would enter the score may be c4, c5, c9, c15, etc....

However, on the 5th grade boys sheet where I want the scores to go, the cells go in order g4, g5, g6, etc....

So when I try to mirror in a big copy/paste type of way, they do not mirror properly. I know how to mirror each cell by hand, but this tournament has well over 500 games and I am looking for a way to mirror in a faster way.

Is this possible?? Any help would be much appreciated and thank you in advance!

Answer 1

Link to a copy of your workbook on a file-sharing site. I only need the Master sheet and one example of the grade level sheets

Answer 2

You can probably use the FILTER function