Hello,
I can do that in max 3 days. Of course the exact solution (layout, implementation, etc) depends on the specific worksheet and its purpose, so without having the worksheet's image and and idea on its purpose, I can't say too much... I may use a combination of VBA code and standard Excel formulas and array formulas.. On my portfolio you can see a calendar implementation done before for a catering company (interactive schedule for reservations, events, etc...)
A few words about me: I'm developing VBA programs for more than 15 years and I'm a trainer for Excel and VBA (all levels) for 12+ years. As you can guess, I have created a plethora of VBA programs and Excel sheets for almost any kind and difficulty level, for both training purposes and business.
Looking forward to hear from you,
Kind regards,
Chriskerpini