My workbook has many sheets labelled by month (Oct 2012, Nov 2012 etc) and every sheet has data in it from rows 16. There are at most 50 or so rows of data (16-66 lets say) but this is variable from month to month.
I have more data that starts at row 191 onwards.

From month to month the gap from the last row from row 16 and the start of the set of data from row 191 can be quite long and it requires alot of scrolling down to get to row 190

I was wondering if I could call up a macro that would hide all data from the last row of data +2 (so that one empty row would exist if I wanted to add another row) up to row 190 so that the data from the rows 16-66 (for example) was close to the data in rows 191 onwards. and if more data were inserted into the data from row 16 onwards another empty row would become visible?