Excel - display only columns with specific month and year

0
votes

Need help!

I have put into row 6 in Excel dates starting from 1st November, 2016 (Cell F6) to 31st December, 2017 (Cell PO6). Cell B1 shows drop down list of months and cell B2 shows years.

I need a tip on how to set formula which will allow me to show only columns of month and year which are chosen in cells B1 and B2. For Example, if i choose November 2016, only columns F:AI will be visible, while columns AJ:PO will be hidden.

Please provide suggestions on how can this formula be formatted in different way, if you have suggestions.

1
vbaexcelexcel-formula
Hiding columns is done through VBA, not by formula. Perhaps you should rephrase your question to make it clear. – Patrick Honorez
Check this question : stackoverflow.com/questions/40629523/… – bzimor
@bzimor yeah, that is the answer :) – Z.Markovic

1 Answers

0
votes

You should write a VBA code combining if...then with 

Worksheets("Sheet1").Columns("C").Hidden = True

The if...then guide is here and the hide column guide is here.