Looking for a macro (automated) method to hide unused columns

Hello,
In the attached file, the crimson/yellowish cells auto-populate based on variables seen on another tab in the "Live" version. So, from left to right there may be anywhere from 1 to 24 dates populated. I am wondering if there is a way to have columns automatically hide/unhide based on whether or not a date populates. Ideally this would not involve a macro "button" but would occur automatically based on whether a column header populates.

Thanks in advance.