Hiding Rows Dependant on Cell Value

[AdamThompson]

Hi there Guyls and Girls,

I've come to beg for help, I've used the forum many times for info and its always been dead useful so thanks for all the other posts.

I’m putting together an excel document and have a need to hide Rows if specific cells have no data in them. I know this has been covered elsewhere but I can’t see to get any of the VBA codes to work with my document (I’m not very god with VBA).

I’ve attached my document.

In the “G-7 Cruise” worksheet I’d like to hide the Row if there is no Data in Column A of that same Row. This would need to be from Row 7 to 306.
Column A has a formula and is populated by the “Connected AC Loads” H Column if it is selected to Y.

Also, the Rows should refresh and unhide/hide if the data appears/disappears in Column A.

Thanks in advanced for any help you can throw my way.