Originally Posted by Xaccers
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.
You could only do this via a Macro unless someone wants to correct me!