View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Kezia Kezia is offline
external usenet poster
 
Posts: 1
Default 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