I have one sheet called master list which is basically a customer list of:

custid, name, address, state, ...
On a different sheet I want to make a report that does something like:

State: <enter state>
(Macro, or auto) Select * from master_list where $State_Col = state

This way I can have a nice formatted report for each state, and I can
simply enter the state and either run a macro, or have it auto run based
upon a change in state to make the rest of the report.

I know this is probably best suited for a database, but for right now we
really like the auto-filter capability and dont want to move everything
to a DB.

Peter