Excel 2007 : Changing Data on one sheet to reflect changes on another.

i thought that was the issue but another problem arose. I need to be able to use the"filter" feature to get high/low scores, alphabetical,etc on columns that are being referenced from sheet1. As you can see on sheet2 of the attached, the blank # came up first. I realize I can just delete the number and add one when another person is added but I will not be the one editing this workbook and do not trust in the ability of the ones doing it.

Hi,

Forum helped me in finding the solution of updating the 2nd sheet based on the updation of 1st sheet.

I am looking for 1 more solution: Is there any possibility of reflecting background cell color and font text into 2nd sheet?

Thanks,
Ram