Hello Group,
I am using Excel 2000 working with an existing spreadsheet trying to modify it for better use among teachers. I have the existing file here for you to download: http://connes.wcpss.net/Excel/
I would like to know if there is a way and/or formula to have the "running records data" sheet gather information on what the teacher entered for the students show up on the "individual" sheet. At the same time I do not want it to bring up the books which have no information entered. For example, if I entered data for "Abe" and it was on books 1-2 and nothing else, I would like only Books 1-2 to show up when I enter Abe's name on the individual sheet. Does anyone have a formula for this?

Thanks,
Ron