I'm an enginerd so I'm sure I can figure it out. Been writing software for
nearly 20 years so I'm sure I can handle it. The deal is that I've never
even attempted to learn VB. I don't necessarily want to pick it up because
I doubt I'll use it enough to justify the time learning it to any great
degree. I think your comment to use the recorder is the best approach.
It'll give me the pieces of code I need so I can clean it up and make it do
exactly what I want. I hate to say it but I hadn't thought of that simple
idea. Doh. :) Thanks!

Cheers
Scott


"Tom Ogilvy" wrote in message
...
Well, Excel has a built in ability to filter, even to another location -
Data=Filter=Advanced filter.

If your criteria is very complex on deciding which rows to hide, you can
put
formulas on the end of the rows to make the determination.

Almost anything you can do manually can be done using code. One way to
get
the code is to turn on the macro recorder (tools=Macro=Record a new
macro), then perform the actions manually.

This give crappy code, but shows you the syntax of the major command that
you need to use. It is very effective if you are using major Excel
capabilities like Advanced filter or Subtotal.

I know I didn't use any functions in the Data menu (except sort), so I
don't
know if you are familiar with these or not, but they may minimize the
amount
of code you need to do.

As far as too vague. Yes, unfortunately, you have to tell the computer in
minute detail what you want it to do - you can't point in a general
direction and and say put it there.

--
Regards,
Tom Ogilvy