This seems to only work for week 1
Week 2 I want it to compare the week 2 number column (Column C) to the names
(column A) and then copy the name into a seperate list but it seems unable to
skip the row inbetween.


Is this possible?


"Bob Phillips" wrote:

This looks like a job for DataFilterAdvanced Filter to me.

You can set a conditional criteria and specify a destination location.

--
HTH

Bob Phillips

"macca" wrote in message
...
I have a spreadsheet which contains people's names and numbers associated
with those people. I would like to set it up so if the number is greater
than 5 then excel will copy the name into a different list. I can do this
with IF statements but i get lots of blank cells where that person does
not
fill the criteria.

Any ideas how to solve this????