Formula to extract updated data in Master


March 1st, 2013 by BenneTan BenneTan

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.

Download File

Leave a Reply

You must be logged in to post a comment.

s2Member®