Master Sheet Autopopulate

Question

I need to create master sheet in excel, then from that master sheet it will need to auto populate data (different course registrations) on to each sheet that it will correspond to. For example, if I have two different courses (CM and NM) being offered and I have registrations coming in for both, how do I get it to auto populate from the master sheet into rosters for CM and NM (other excel sheets) for my staff automatically. I only need to pull certain columns from the master sheet, so it is not all of them. I included the 7 things I need to only put on the roster to update automatically from the master sheet which has over 26 columns of information. I know there is a way to link cells individually, I am looking on more doing a whole sheet to auto do it. I dont know if I need to write some kind of rules for the different course codes to work out all the transfer of data but I have never done anything on this scale before.

Answer 1

The master sheet previously that we had (which was filtered like suggested) got incorrectly sorted and someone deleted entries out of the master sheet so I need a way for these rosters to populate from this master sheet. Realistically I am the only one edited the master sheet but they need a way to view rosters whenever they need to without referring to the big master sheet.

Answer 2

Hi,

If the number of courses is limited, then you may use the FILTER() function on each sheet.