Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I m following directions and can't delete dup rows in excel | Excel Discussion (Misc queries) | |||
program excel worksheet to automatically not print blank rows | Excel Worksheet Functions | |||
How can I delete rows from Pivot Tables in Excel 2000 as in 97 | Excel Discussion (Misc queries) | |||
How do I delete blank rows at the bottom of a spreadsheet to get . | Excel Discussion (Misc queries) | |||
How do I remove blank rows in Excel? | Excel Discussion (Misc queries) |