Hello, In Excel 2007 I am trying to create a new sheet that will list all
rows that have the same entry in it. I can not use the filter option on the
main sheet as each person will only be allowed to see their own data so is
there are function that might assist me?
I.e. If the person type Paul into a cell and the month number in to another
then the list that is created and displayed is all the rows that contain the
name Paul in column R for the given month.

Thanks for any asssitance offered
--
Jim