many thanks Andy for your very prompt reply; yes this does excatly what I
wanted it to do. Many thanks again
Jane11804
"Andy" wrote:
Hi
You should have a look at Data/Filter/Autofilter. I think it might be what
are wanting.
Andy.
"Jane11804" wrote in message
...
I have one mail worksheet with all of my data on it, then four other sheets
containing "if" formulas to split the main data into sections. To make
this
easily printable, I think I need a conditional format to hide the rows
with
no data in; ie IF D4=0, ROW HEIGHT=0, ROW HEIGHT=20
Is this possible?
Thanks in advance