Thread: excel programming
View Single Post
Old 12-02-2004, 17:47   #7
Tricky
I've been here before?
 
Tricky's Avatar
 
Join Date: Jun 2003
Location: I am house...
Services: $KY+HD - BT Infinity
Posts: 2,283
Tricky is the helpful oneTricky is the helpful oneTricky is the helpful oneTricky is the helpful oneTricky is the helpful oneTricky is the helpful oneTricky is the helpful oneTricky is the helpful oneTricky is the helpful oneTricky is the helpful oneTricky is the helpful oneTricky is the helpful oneTricky is the helpful oneTricky is the helpful oneTricky is the helpful oneTricky is the helpful oneTricky is the helpful one
Re: excel programming
Quote:
Originally Posted by 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.
You could only do this via a Macro unless someone wants to correct me!
Tricky is offline   Reply With Quote