Dear Friends



I have a calendar made out on weekly on/off basis. I am working at an offshore location where we work for one week and then go town for one week rest.
I need to use a button where if I click "Duty" , ALL and ONLY the duty weeks must show up and if I click "Rest" button, ALL and ONLY Rest weeks must show up in the Excel sheet.
I also need that after button brings out the required resuts, the called off coloumns could change color also.
If it is possible with a function then I would be very happy as people will not have to enable macros at opening the calendar.

Attached Files

Calendar new.xlsx (15.8 KB, 8 views)

I'm not clear on what you mean about the colours but you can use CustomViews to achieve your primary goal. Simply hide one set of columns, then select View - CustomViews - Add... and save that view. Then show all columns and hide the other set and add another view. You may now switch between the two views as you would like.

Thanks Debaser
Actually by spending some time, I managed to work around my problem.
I am happy that being a learner, I managed myself to do what I wanted.
If you see the attached file, I do have another question ,I am unable to do:
I made the calendar for 7/7 days ON/OFF shown with dropdown list and also to show a full calendar but some guys around me are working on 27/29 days Rota and they are asking me to do the same for them. I am totally blank how to do this?
These people come on duty for 27 days and goes for rest for 29 days and they want to get a calendar from me where their duty and rest days must be highlighted in different colors, just like the attached one, made by me.
Could you please help?

Attached Files

Calendar new.xlsx (36.9 KB, 8 views)

I would I think change the layout like this.

Attached Files

Calendar new (1).xlsx (48.9 KB, 11 views)

Thanks very much, sir for the help. I could further tune with Excel functions.