Not sure why you need an extra sheet. Why not switch on AutoFilter and
filter on the percentage column. You could use a simple filter or a custom
filter, for example, greater than or equal to 50%

That would hide any rows that don't meet the criteria. Just print the sheet
while the filter is in. To return to the "normal" view, just choose Show
All

Regards

Trevor


"360Kid" wrote in message
...
I have a sheet with columns of clients and percentages. I would like a new
sheet to pull only those client names that exceed a certain percentage
i.e.
50% and create a list with only those clients.

Is there a lookup function that can do this?

thanks loads.