software

I have one mail worksheet with all of my data on it, then four other sheets
containing quot;ifquot; 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 advanceHi

You should have a look at Data/Filter/Autofilter. I think it might be what
are wanting.

Andy.

quot;Jane11804quot; gt; wrote in message
...
gt;I have one mail worksheet with all of my data on it, then four other sheets
gt; containing quot;ifquot; formulas to split the main data into sections. To make
gt; this
gt; easily printable, I think I need a conditional format to hide the rows
gt; with
gt; no data in; ie IF D4=0, ROW HEIGHT=0, ROW HEIGHT=20
gt;
gt; Is this possible?
gt;
gt; Thanks in advance
gt;
gt;
gt;
gt;

With condition formatting it is not possible as condition formatting
only does formatting. I believe tha only way to do it via a macro.
Maybe you could ask this question in the programming section of this
forum.

Rgds.--
Infinity
------------------------------------------------------------------------
Infinity's Profile: www.excelforum.com/member.php...oamp;userid=32725
View this thread: www.excelforum.com/showthread...hreadid=527524many thanks Andy for your very prompt reply; yes this does excatly what I
wanted it to do. Many thanks again

Jane11804

quot;Andyquot; wrote:

gt; Hi
gt;
gt; You should have a look at Data/Filter/Autofilter. I think it might be what
gt; are wanting.
gt;
gt; Andy.
gt;
gt; quot;Jane11804quot; gt; wrote in message
gt; ...
gt; gt;I have one mail worksheet with all of my data on it, then four other sheets
gt; gt; containing quot;ifquot; formulas to split the main data into sections. To make
gt; gt; this
gt; gt; easily printable, I think I need a conditional format to hide the rows
gt; gt; with
gt; gt; no data in; ie IF D4=0, ROW HEIGHT=0, ROW HEIGHT=20
gt; gt;
gt; gt; Is this possible?
gt; gt;
gt; gt; Thanks in advance
gt; gt;
gt; gt;
gt; gt;
gt; gt;
gt;
gt;
gt;

Thanks for the feedback!

Andy.

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