Macro to generate daily input and retrieve historical input

[Aoleone#]

Hello

I want to create a daily task list template. The idea is to have a VBA macro whereby the record of the daily input( 5 columns after column G) will be hidden and new columns (with next day date) generated by clicking "Next day". A click on the "previous day" button to retrieve previous day's input. Any other date besides previous and next will be selected from the date picker.

Columns C to G are static pre-populated fields whilst the next 5 columns after column-G changes by date hence why the column G pane is frozen.

NOTE: I have formulas in column N,O,P which calculate the percentage of task done per day.


Any VBA ideas on this is much appreciated?

Gracias.