I have an order form that is filtered based upon the rows that have order data (qtys) entered, if nothing is ordered the form collapse's those lines so only the items ordered remain visible. The filter works fine but when I print the form it still prints 5 pages even though when filtered it's only two pages. Is there a way to automatically keep the blank pages in the middle from printing? Thanks!
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Collapse blank pages in the middle of a form
Similar threads
- Question
