Excel report which excludes the blank rows?
 

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?

Excel report which excludes the blank rows?
 

with your table in the first row (headers present in row 1), do Data=Form

If that works, then your finished. (however, I don't expect it to work
since it only supports 32 columns and I believe you are talking about 89.)

If not, then you might need to learn how to program userforms:

http://j-walk.com/ss/excel/tips/tip84.htm

See this tutorial here
http://www.dicks-blog.com/excel/2004...g_userfor.html

http://support.microsoft.com/default...b;en-us;829070
How to use Visual Basic for Applications examples to control UserForms in
Microsoft Excel


XL97: How to Use a UserForm for Entering Data (Q161514)
http://support.microsoft.com/?id=161514

XL2000: How to Use a UserForm for Entering Data (Q213749)
http://support.microsoft.com/?id=213749

If that doesn't sound appealing, then perhaps you want to mimic a paper form
on the worksheet.

You would then need to use code to move it into a Table.

There may be other possibilities as well as entering it directly.

--
Regards,
Tom Ogilvy


"Chasman" wrote in message
...
Thanks Trevor. I took the AutoFilter lesson on the Microsoft website and
it
is exactly what I need. I am obviously a "newbie". Thanks again. Now I
need an Excel input form (similar to one which Access would create) for my
office manager to input the data to the spreadsheet. Although, she could
just bring up the worksheet and enter directly to the spreadsheet itself.

Again, thanks,

Chasman

"Trevor Shuttleworth" wrote:

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?