Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditionally Hiding Rows
I appreciate your help. I have a spreadsheet that contains several worksheets. On one of the worksheets, the values in one column are determined by the results of an IF statement that looks at conditions in another worksheet. The user wants a row in the dependent worksheet to be automatically hidden if the results of the IF statement are a certain value. For example, if the IF statement in cell D8 returns "" (or blank), then the user wants row D to be automatically hidden. Is there a way to do this? I am not sure of the version of Excel he is using, but feel sure it is 2000 or higher. -- Llobid I am a Technology Specialist and District WebMaster for a school district in Texas. ------------------------------------------------------------------------ Llobid's Profile: http://www.excelforum.com/member.php...fo&userid=7777 View this thread: http://www.excelforum.com/showthread...hreadid=532080 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditionally Hiding Rows
D is a column in most worksheets, did you mean to hide Row 8 (possible with VBA code), or column D (not possible for your purposes)? -- Llobid Wrote: I appreciate your help. I have a spreadsheet that contains several worksheets. On one of the worksheets, the values in one column are determined by the results of an IF statement that looks at conditions in another worksheet. The user wants a row in the dependent worksheet to be automatically hidden if the results of the IF statement are a certain value. For example, if the IF statement in cell D8 returns "" (or blank), then the user wants row D to be automatically hidden. Is there a way to do this? I am not sure of the version of Excel he is using, but feel sure it is 2000 or higher. -- Bryan Hessey ------------------------------------------------------------------------ Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059 View this thread: http://www.excelforum.com/showthread...hreadid=532080 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditionally Hiding Rows
Sorry ... yes, I meant row 8 ... NOT column D needs to be hidden. -- Llobid I am a Technology Specialist and District WebMaster for a school district in Texas. ------------------------------------------------------------------------ Llobid's Profile: http://www.excelforum.com/member.php...fo&userid=7777 View this thread: http://www.excelforum.com/showthread...hreadid=532080 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditionally Hiding Rows
The easy way is to select the first rown then Data, Filter, Auto-filter and dropdown column D and select Non-Blanks. -- Llobid Wrote: Sorry ... yes, I meant row 8 ... NOT column D needs to be hidden. Bryan Hessey Wrote: D is a column in most worksheets, did you mean to hide Row 8 (possible with VBA code or by Filter), or column D (not possible for your purposes)? -- -- Bryan Hessey ------------------------------------------------------------------------ Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059 View this thread: http://www.excelforum.com/showthread...hreadid=532080 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditionally Hiding Rows
The easy way is to select the first row then Data, Filter, Auto-filter and dropdown column D and select Non-Blanks. -- Llobid Wrote: Sorry ... yes, I meant row 8 ... NOT column D needs to be hidden. Bryan Hessey Wrote: D is a column in most worksheets, did you mean to hide Row 8 (possible with VBA code or by Filter), or column D (not possible for your purposes)? -- -- Bryan Hessey ------------------------------------------------------------------------ Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059 View this thread: http://www.excelforum.com/showthread...hreadid=532080 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditionally Hiding Rows
Thanks for your help; I have used the Excel filters before, but have never noticed that specific capability. I really appreciate it. -- Llobid I am a Technology Specialist and District WebMaster for a school district in Texas. ------------------------------------------------------------------------ Llobid's Profile: http://www.excelforum.com/member.php...fo&userid=7777 View this thread: http://www.excelforum.com/showthread...hreadid=532080 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
print area selection slows excel, formula for hiding rows?? | Excel Discussion (Misc queries) | |||
Hiding Rows when a cell = 0 | Excel Discussion (Misc queries) | |||
Conditionally Hide Rows | Excel Discussion (Misc queries) | |||
Hiding rows before printing | Excel Discussion (Misc queries) | |||
How do I stop an Excel sheet from automatically hiding rows when . | Excel Worksheet Functions |