Thread: can you hide rows with a formula?

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

You'll have to bear with me because charts aren't one of my strong points to say the least !!

The only way you can hide rows (set their width to zero) is either manually, or a macro.

That brings us to the question, can you run a macro from a formula.
Well no, but... see thread Can I start a macro from a cell by using a formula

You can't hide rows with a formula but try data?filter>autofilter

--
Don Guillett
SalesAid Software
donaldb@281.com
"david" <david@discussions.microsoft.com> wrote in message
news:CDE906A8-DBFE-46DA-8767-8186E6951090@microsoft.com...
> 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
>