Want to show/hide mutiple grouped coloumns in Excel sheet with a button
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.
|