One of our colleague faces this problem:
“Currently I am updating information in a master sheet as and when I receive registrations for courses; eg: name, contact, organization, etc. I also need the same information in a separate sheet as a name list for that particular course and date. When there are changes; eg: additions, postponements, cancellations or amendments. currently I have to amend both ends. I want to make it such a way that when I amend in the master sheet, the separate name list sheet gets updated.”
So, here’s our solution for her problem. You simply have to fill in the cells in B3:C3 in the NAMELIST sheet according to the course & date you want to see.