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!!!