Re: Conditionally Unhide Columns
To explain, the worksheets are performance data for the financial year. Each month we have to produce reports for the teams based on their activity to date each month, so for example team A's data might be April - 23, May - 27, June - 33, July - 21 etc. As the team has not done anything yet in November, December, January, February or March of this financial year, I want to hide those columns.
At the moment, the months October 05 to March 06 have been manually hidden and so this month I will have to go through all 56 spreadsheets manually unhiding October, then next month do the same for November, etc. etc.
I thought it might be possible to automate the hiding and unhiding of columns, which is why I posted my question. And we're so close to a solution!
Would a possible solution be to have a cell, e.g. AA1, on the master spreadsheet, in which I type the last month I want to display? The VB code could then look at that cell and hide all the month columns following that month? If so, how do I do that?