Macro to hide rows
Jeff, the simple answer to your problem would be a macro like (*assumes cell
below total is blank, and no list date is blank): Do While Not ActiveCell.Value = "" If Not ActiveCell.Value < Now() And Not ActiveCell.Value = "Total" Then ActiveCell.EntireRow.Hidden = True ActiveCell.Offset(1, 0).Select Loop However, this will not adjust your total to show only the visible rows, nor will it allow you to copy only the visible rows. Is this what you really require? Jeff "Jeff" wrote in message ... I have several spreadsheets in a file with each shet containing the days of the months down column A Each file contains only one month. Column A Ex :Row 1 09/01/03 Row 2 09/02/03 Row 3 09/03/03 After 9/30/03 there is a total line. Each day I unhide all the rows (with a macro)and then enter data for the previous day then rehide all rows. In some cases there are mutiple lines with the same date on a sheet if more than one transaction occurred. like 09/03/03 might be listed on row 3 row 4 and row 5 of sheet1. I have to show this file to others and they only want to see data through the previous day, hiding all future dates. For example today after putting in values for 9/04/03 I rehide all rows after 9/04/03 to the toal line. Does anyone know how I would set a macro up for this? Thanks |
All times are GMT +1. The time now is 08:53 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com