Excel Novice: Delete blank rows
 

Forgive me for my lack of knowledge on the subject. I have a worksheet
populated with select data from another worksheet (via IF statement).
Where the IF statement is FALSE I get blank rows (which is what I
want). Is there a way to automatically delete or hide blank rows each
time the worksheet is refreshed with new data. I only want to see the
rows where the IF statement is TRUE.

THANKS! Lisa

Excel Novice: Delete blank rows
 

Maybe you can apply data|Filter|autofilter

and filter to show the non-blanks or True's?

Kezia wrote:

Forgive me for my lack of knowledge on the subject. I have a worksheet
populated with select data from another worksheet (via IF statement).
Where the IF statement is FALSE I get blank rows (which is what I
want). Is there a way to automatically delete or hide blank rows each
time the worksheet is refreshed with new data. I only want to see the
rows where the IF statement is TRUE.

THANKS! Lisa

--

Dave Peterson

Excel Novice: Delete blank rows
 

If you delete rows the formula in the remaining cell will most likely change
(try it on a dummy copy of your file) Would you be happy with a worksheet
where the link to the source has been broken?
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Kezia" wrote in message
ups.com...
Forgive me for my lack of knowledge on the subject. I have a worksheet
populated with select data from another worksheet (via IF statement).
Where the IF statement is FALSE I get blank rows (which is what I
want). Is there a way to automatically delete or hide blank rows each
time the worksheet is refreshed with new data. I only want to see the
rows where the IF statement is TRUE.

THANKS! Lisa