| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
remove unused Rows (with 0 qty)
thanks for all replies.. but maybe I adventured myself in a 'far beyond my knowledge' situation... here attached excel document is exactly what I use as an order form. please see the attached worksheet. You see there is items ordered in rows 5 to 9 and 19 to 23. in the TOTAL (column L) I want all the rows with a ZERO to be hided! So I could ONLY print the row with items ordered ... let me know what you think about it... thank you very much, I feel like I can still pull this one off with your help... jim b. :) +----------------------------------------------------------------+ | Attachment filename: jbarber_example_excel.xls | |Download attachment: http://www.excelforum.com/attachment.php?postid=361880| +----------------------------------------------------------------+ ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
remove unused Rows (with 0 qty)
This question has also been posted in the original thread.
-- Regards, Tom Ogilvy "jbarber" wrote in message ... thanks for all replies.. but maybe I adventured myself in a 'far beyond my knowledge' situation... here attached excel document is exactly what I use as an order form. please see the attached worksheet. You see there is items ordered in rows 5 to 9 and 19 to 23. in the TOTAL (column L) I want all the rows with a ZERO to be hided! So I could ONLY print the row with items ordered ... let me know what you think about it... thank you very much, I feel like I can still pull this one off with your help... jim b. :) +----------------------------------------------------------------+ | Attachment filename: jbarber_example_excel.xls | |Download attachment: http://www.excelforum.com/attachment.php?postid=361880| +----------------------------------------------------------------+ ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
remove unused Rows (with 0 qty)
thank you very much... this particular script resolved all m headaches!!!!! please get in touch with me PEACE!!!! I want give you a tee-shirt and stuf to thank you!!! : ----------------------------------------------- ~~ Message posted from http://www.ExcelTip.com ~~View and post usenet messages directly from http://www.ExcelForum.com |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hide unused rows and columns | Excel Discussion (Misc queries) | |||
| Need to remove unused rows and columns to minumize size | Excel Worksheet Functions | |||
| How can I remove an unused shortcut label from a Worksheet row? | New Users to Excel | |||
| How do i remove unused cells in excel? | Excel Worksheet Functions | |||
| How do I get rid of unused rows at the bottom of the book? | Excel Discussion (Misc queries) | |||
![jbarber[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
