Hi everyone

It is my first post here. Ive been consulting this site and it is very
helpful and Ive learned numerous relevant tips.

I want to set up an Order Form (with all items, price etc) but this
document is HUGO (more than 1000 items) and it's a pain in the back to
print.

I need to build a macro that will check every line (to see if there's
anything ordered) and where ever there is units (to keep it) and where
there's no unit, simply hide or delete the row..

let me know if this make any sens
any help would be greatly appreciated

thank you very much in advance..
jim barber


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/