Hi guys I recently decided to put in my students' attendance into a
worksheet. A sample of one of the student's sheets can be seen at
http://i291.photobucket.com/albums/l...attendance.jpg (at lot
easier to upload a screenshot than to explain ;))

Anyway I also consolidate the particular stundet's payment records as seen
at http://i291.photobucket.com/albums/l...em/payment.jpg

At this moment however, I manually enter data for BOTH the sheets.
(sub-total for the payment sheet is calculated automatically however).
However I would like to only fill up the attendance sheet while the payment
automatically grabs the necessary info. As can be seen, it needs to grab the
date, amount and receipt number. (I guess I could edit it later to include
the others such as payment mode and so on)

However, it should only grab data when there is actually some sort of
information (i.e don't grab when amount due is listed as NA). How would this
be possible? Thank you in advance.