I am making up a order form to make my life easier when ordering materials. I have made up a list that has multiple sections. What I would like to have is a way to print a page with any items that are >0. I have searched Google and found little to point me in the right direction. Here is my workbook and how I am planing on using it.
Worksheet "Takeoff": enter fittings and pipe needed.
Worksheet "Totals": Takes the info from "Takeoff" and puts it with the corresponding parts
Worksheet "Order Form": what I would like to do is to take the items that require ordering from "Totals" and lay it out for easy faxing/printing etc. I would like only the items required to be on this form.
If someone would be so kind to help me out I would be very grateful.
Bookmarks