Hide/Show Columns based on Cell Value

Good Morning!

Really new to using excel and was hoping someone could help me. So i have a spreadsheet which looks at an accounts values year on year. I have two worksheets, 'Data' which i enter the expiring and renewal values and 'Summary' which summarises the values.

What i would like is a code for View Code which automatically updates, that hides columns C,D on my Summary sheet when there are no expiring values (columns A,B,C,D) entered on my Data worksheet.

Any and all help is greatly appreciated.

Hi Naveed,

Please find the worksheet attached.

Essentially what i'd want is if there is no data in columbs A/B/C/D on the Dump Zone tab then columns C/D to be hiden on the Summary tab, which is shown in the attached wokrsheet (without C/D being hidden clearly, as that is what i'm here for).