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