Hiding Excel rows on condition without using macro

[deepakborse]

Hello folks,

I have a tool which generates report in excel format. All the changes have to be done in excel template and then tool takes care of all data as per template.

I need to hide some rows depending on a value in another tab, Macro would make it very simple but i CANNOT USE MACRO in this tool.

Lets say i have Sheet1, sheet2 and sheet3.

How can i get below done?
If Sheet3.A4 = 0 then Hide 15:21 rows of sheet 2.
and i need to write this expression in sheet 1.

Is it possible? any help would be very appriciated.

Many thanks. Cheers!!!

[Mike1001]

Without using a macro, I don't see any chance to get this done.
Even if you came up with some fancy autofilter setting, you would still need to have a macro which will refresh the filter setting.

Sorry!

[davesexcel]

Have you tried the Autofilter?
You will have to manually set the filter if you don't want a vba solution