Hi, I was hoping someone could help me.
My Excel Spreadsheet is updated each month with that months' figures. imported from elsewhere
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 rows
Kind of like a filtering system but instead of filtering make it so that the filter works on a cumulative basis i.e. showing everything up to that point and hide cells beyond that point.
Please Someone Help Me. I'm new to VBA and im just trying to get to grips with coding.
My Excel Spreadsheet is updated each month with that months' figures. imported from elsewhere
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 rows
Kind of like a filtering system but instead of filtering make it so that the filter works on a cumulative basis i.e. showing everything up to that point and hide cells beyond that point.
Please Someone Help Me. I'm new to VBA and im just trying to get to grips with coding.