I did not explain the issue as well as I should have. The autofilter
would work for what I said, but the output really needs to be more
formal and finalized than an autofilter screen...

After the sheets are shortened to only the needed information, they
will be sent out as a report to users. I think that the process needs
to be automated such that all preferences are made on an initial "menu"
sheet, all changes are made upon clicking submit, and a final output is
generated.

...any ideas?


Thanks.


--
TEAM
------------------------------------------------------------------------
TEAM's Profile: http://www.excelforum.com/member.php...o&userid=22810
View this thread: http://www.excelforum.com/showthread...hreadid=539208