Hi
I have a report with actual data for 12 months and then the budgeted data for 12 months in columns.
I use formulas to determine the total at the end of the year.
My June report total column will be calculated as Jan to May Actual + June to Dec Budget.
I hide the columns not used (Jun to Dec Actual and Jan to May Budget) manually.
Is there an excel formula to hide a column or adjust their width based on a cell value?
I can do this with VBA, but would prefer an Excel formula option.
Gabriel
I'm afraid not. Excel formulas can not manipulate column width. But there are ways to present the data you want with formulas that extract/filter the correct columns from the Actual/Budget table.
Could you upload a file showing how your data is structured? Remove any confidential information.
