[Xaccers]

Thanks Richard

Do you know how I can get it to hide rows where the value isn't 1?

Basically I've got several clients' backup reviews allocated to several colleagues.

I want to produce on a seperate sheet within the workbook a list of allocated clients for each collegue.
Allocation is done by putting a 1 in the collumn/row of colleague/client

So I'm getting the list when I try what you said, but it's showing all the falses in between client names.