can you hide rows with a formula?

G

Guest

on my last sheet there should be an overview of the data selected by the
user. If the user doesn’t select all the blocks with data “because he thus
not need that particular blockâ€. There will be empty rows between the
information on the last sheet!
I need all the info under each other, so that the user will have a short
clear overview that will fit on 1 page to print. (this should be all
automatic).

Is this possible by hiding the empty rows with a formula? Or is there
another way?

(The sow called “empty rows†do contain formulas that hide the data blocks
that the user thus not need)

Please help me I have tried so many things and still without resold.

Greets david
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel EXCEL - using a date dependant formula to hide rows 3
Hide columns based on row values 2
Hiding/Unhiding Rows Automatically 1
Calculate number of rows and apply formula 4
hiding rows containing formulas which return zero values 3
Excel How to capture data to a specified excel sheet(first workbook) of two different workbooks from the 0
Help on Macro to hide empty rows 4
Hide Rows or Coloumns using formulas 5

Top