VBA to hide/show rows based on cell on another tab

[Sunny London]

I've been looking through lots of other posts about showing and hiding rows and have been trying to amend the code to work on my spreadsheet, but don't know enough about VBA and can't make it work. Can anyone help please?

On my Data Input tab, if cell B12 is empty then I want rows 14,34 and 37 on my Bal Sht tab to hide automatically. If cell B12 on the Data Input tab has anything in it, then rows 14,34 & 37 on my Bal Sht tab should show.

Also, if cell B13 is empty then rows 15,35 & 38 should be hidden or if B13 has anything in it, then rows 15,35 & 38 should be visible.

Any suggestions?
Thanks

 

[VoG]

Nearly

.Rows("37:40").Hidden = Target.Value = ""

To use code tags

[code=rich]
your code
[/code]

 

[Sunny London]

Ah, of course. It seems so obvious now! Thank you.

Thanks for reminder about using code tags too.