How do I create a new worksheet for a subset of data

[Guest]

Folks

What I want to do seems so simple I can't figure it out.

I have a worksheet with project issues. One of the columns is 'Client' and
another is 'Closed'

What I'd like to do is to maintain the 'master' worksheet, with all this
information, and (as if by magic) for other worksheets (e.g. labeled Client
1, Client 2, Client 3 and 'Closed issues') to be populated accordingly, so
that I can easily print off the 'Closed issues' worksheet without having to
'Filter/Autofilter/etc etc'/

What I've done now is to put 'if' formulae in my 'Client 1' etc worksheets,
which gives me that data that I want but of course now has blank rows where
the 'master' worksheet data belongs to another Client.

I know I can 'Filter/Autofilter' these out manually each time but I'm
thinking, since this IS 2006, there MUST be a neater way of doing it?

Any thoughts/thoughts appreciated.
Thanks
Bennie
London

 

[Guest]

If you don't want to use access how about using scenarios so you click on the
scenario you want and then you can print out what you want.
Alternatively record a macro where you filter the list by what you want,
print it and then unfilter it. Then all you do is click your macro button and
you have your answer?

 

[Guest]

Thank you Michael.

Re-reading my original post I'm amazed you could make any sense of it

I've not worked with scnenarios much, will give that a go and I also like
the idea of macro/filter - many thanks!