sanilmathews
Board Regular
- Joined
- Jun 28, 2011
- Messages
- 102
Hello,
I am trying to put together a tracker for an entire year, where each day in a year is laid out in each column as dates. Please note, for convenience, I am designating 31 columns for each month irrespective of the days a month has.
With this requirement in mind, I would need a macro that would allow the user to see only 31 columns at any given moment (excluding the first two columns which would contain labels, and the last two columns for totals in the entire table). That is, all the other 341 of 372 columns are hidden. The macro should help the user to scroll left and right by 31 columns by hiding all other dated columns.
To give a perspective, if I have the first day of the year in column C1, the macro would help the user to view only 31 columns and all other columns hidden.
To give a simple comparison, the function that I am looking for is something very similar to the calendar on the bottom right corner of the PC. Except that all dates in a year are listed by columns in excel.
Thanks in advance
I am trying to put together a tracker for an entire year, where each day in a year is laid out in each column as dates. Please note, for convenience, I am designating 31 columns for each month irrespective of the days a month has.
With this requirement in mind, I would need a macro that would allow the user to see only 31 columns at any given moment (excluding the first two columns which would contain labels, and the last two columns for totals in the entire table). That is, all the other 341 of 372 columns are hidden. The macro should help the user to scroll left and right by 31 columns by hiding all other dated columns.
To give a perspective, if I have the first day of the year in column C1, the macro would help the user to view only 31 columns and all other columns hidden.
To give a simple comparison, the function that I am looking for is something very similar to the calendar on the bottom right corner of the PC. Except that all dates in a year are listed by columns in excel.
Thanks in advance