To hide and unhide empty rows in between rows with data in them...
Posted by Chris Rock on June 25, 2001 12:10 PM
I have a worksheet that I update daily. It contains entries for each day in the month (one day per row), and then a Totals Row in row 35.
Everything in between the current day and the total needs to be hidden, so each day I manually select the rows between the current day and the Totals Row, and I hide them. The following day, I unhide all the rows, and re-hide the rows between the NEW current day and the Totals Row.
Can someone help me automate this process? I'm guessing the easiest thing would be a macro that unhides the top row of many hidden rows.