|
|
|
|
Okay - thanks.
"Ken Wright" wrote:
Not without resorting to VBA code. Autofilter is a solution that will
require just two mouse clicks to hide all the unnecessary rows.
--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03
----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------
"Ladyra" wrote in message
...
I looked at filters but I was really just wanting a formula that would
hide
or delete a complete row if there was no selection by "X" in that row - is
this possible? Thanks for your help.
"Ken Wright" wrote:
Take a look at Data / Filter / Autofilter on whatever field denotes
being
chosen
http://www.contextures.com/xlautofilter01.html
--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03
--------------------------------------------------------------------------
--
It's easier to beg forgiveness than ask permission :-)
--------------------------------------------------------------------------
--
"Ladyra" wrote in message
...
I have a nine page order form - my question is if it is possible to
hide a
row if the item in that row is not chosen. I want to end up with a
two or
three page order form showing customer choices instead of nine pages
of
half
filled in rows - any suggestions? Thanks.
|