The easiest way would be to use AutoFilter ... if that's not what you mean
by hiding and hiding the rows.

Regards

Trevor


"Chasman" wrote in message
...
I have an Excel spreadsheet where each row in Col A is a subdivision lot
number. All the lots are entered at time purchase. When a lot sells, we
enter the remaining info, eg. Cust Name (Col B), Sales Price (Col C), etc.
out to the 89th column. How do I construct another spreadsheet or print a
report which would only show or print the active lots (those which have
sold)
automatically without having to hide and unhide rows?