Hi,
My Excel Spreadsheet is updated each month with that months' figures.

I.E.
In Cell Range D3-D75 Contains Dates (Jan 2010 - Dec 2015)
Thus the Rows 3 - 75 have corresponding data for each month. It is updated with the next months' figures on a monthly basis.

I want to create a Macro where I can UNHIDE the relevant Rows (all dates from Previous Months to the Present Month) and HIDE future months that havent been filled.

I have created a drop-down list containing each month correspding to the Cells D3-D75 in A2.
I was thinking of creating a loop in order for Cell A2 to lookup the Array Cells(D3-D75) until the dates correspond with eachother and thus hide the following future date rowsMonthly Reviews.xlsx.