Forum Discussion

Copper Contributor

May 12, 2020

Solved

Invisable Rows

Question How do I create (in)visible cells based on a value in a certain cell? Specifications In an Excel file I created I have a number of rows that only need to be visible when a certain quest...

excel

Excel on Mac

Formulas and Functions

bhushan_z
May 12, 2020
StijnCl Try the attached file.

Note: Macros are for fixed rows and cells. If you insert/delete rows, it might fail.

TEST_2020 Werkelijke brandstofkosten.xlsm73 KB

bhushan_z

Iron Contributor

May 12, 2020

StijnCl Try the attached file.

Note: Macros are for fixed rows and cells. If you insert/delete rows, it might fail.

TEST_2020 Werkelijke brandstofkosten.xlsm73 KB

StijnCl

Copper Contributor

May 12, 2020

bhushan_z You're the best! It was just the other way around. So "Ja" was visable and "Nee" was invisible. But I changed it myself. Thanks for your help! Much appreciated!