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/

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/

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