Hello,

I am working with a master spreadsheet that lists around 200 food products and their various conditions i.e. vegetarian, gluten-free, dairy-free etc. I have created a secondary sheet for each of the separate conditions and linked them to the master sheet so when I change the vegetarian status of a product on the master list, the secondary spreadsheet (which for example, lists all the vegetarian products) gets automaticaly updated. I completed this using a an IF statement (whereby =1 means it has the number 1 listed in the vegetarian column, indicating it is vegetarian):

=IF('[Example excel.xlsx]Entree!$F$6=1, '[Example excel.xlsx]Entree!$B$6, "")

My problem is that when I change products on the master list from vegetarian (1 status) to non-vegetarian (blank) the secondary, linked, vegetarian list now has a blank row.

Is there a VBA, macro, or IF code that the blank rows in the secondary vegetarian list can be automatically hidden, and if the become vegetarian again (meaning they should appear in the list) they become unhidden?

Thank you kindly,
Megan