| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I need an If statement for Excel that excludes empty cells | Excel Worksheet Functions | |||
| Replace (blank) entry in a pivot report with clear cell | Excel Discussion (Misc queries) | |||
| Automate Excel report to place certain data into existing report? | Excel Worksheet Functions | |||
| How do I do numbering of rows in Excel when there are blank rows? | Excel Discussion (Misc queries) | |||
| How do I delete blank numbered sheets after my report? | Excel Worksheet Functions | |||
Threaded Mode
