hide rows based on value on another worksheet

Question

I need help with code to unhide rows 7 and 8 on sheet 2, if cell I12 on Sheet 1 = "2", and hide them if = "1" or "NA".  Both sheets are password protected, and the value in I12 is populated by a Vlookup formula.

Thanks,

Scott

Answer 1

Hi,

Please refer to the link below which discusses about the similar issue.

https://social.technet.microsoft.com/Forums/office/en-US/273d8cd7-d1b9-41d5-a164-a95c40a0a77c/auto-hide-rows-based-on-another-cell-value-from-another-sheet-within-the-workbook?forum=excel

If you have any other questions related to Office products, reply and I’ll be glad to assist you.

Answer 2

Thanks Suvanna!