VBA to Hide and Show Rows

[pyroo]

Hi,
I have 2 worksheets in a workbook with below names.

1) Input
2) Output

Input is where users can enter data in given fields.
Output is where the data entered in Input is reflected through cell referencing.

Question: It is possible to have a VBA for hiding/showing all those cells which are blank in the output. So that the data is compressed to only what is available or entered by the user in Input for print purpose?

Blank refers to, the user has not entered any data in the corresponding input field thus the output where the cell reference is in place will not show any result.

[Kevin#]

Was not quite sure what you really wanted but see if some of this points you in the correct direction.
The subs assume that data is in A2 to Z1000 with headers in row 1 and in column A
Rows will be hidden if columns B to Z blank
or if rows B to Z not blank
The 3rd sub unhides all the rows

If this is not what you want, then please attach a workbook with one sheet showing the "before hiding" appearance
and another sheet showing the "after hiding" appearance

Please Login or Register  to view this content.

Please Login or Register  to view this content.

End Sub

Please Login or Register  to view this content.

[pyroo]

Hi Kevin#

I have attached my file.

So in the output sheet, if any of the values in all domain is blank. That particular domain and its value area is to be hidden.

Thanks

[Kevin#]

One way to achieve this is to use conditional formatting, selecting the whole of the range that depends on the same condition, and make both background and text colour WHITE if condition is met. Makes it disappear on the screen.

Range Selected = B14 to M21

Formula used for conditional formatting:

=COUNTIF($F$16:$M$21,"")>0
which translated into English says to apply the formatting if there is at least one cell in that range whose value =""

You could apply a similar condition to the other ranges and domains

see attached file
Look at the rule in Conditional Formatting/Manage Rules