Scrolling left and right in a calendar

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
 

Excel Facts

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off

NoSparks

Well-known Member
Joined
Mar 15, 2013
Messages
1,344
Office Version
  1. 2010
Platform
  1. Windows
Hello sanilmathews,

This question is more than a month old but has garnered no responses to date.
Are you still in need of a solution ?
 
Learn Excel from Bill Jelen

Understanding data is crucial, and the easiest place to start is with Microsoft Excel.

Forum statistics

Threads
1,151,587
Messages
5,765,300
Members
425,271
Latest member
kristyfinn

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top