+ Reply to Thread
Results 1 to 2 of 2

Print only items with a quantity >0

  1. #1
    Registered User
    Join Date
    06-10-2009
    Location
    here
    MS-Off Ver
    Excel 2003
    Posts
    36

    Print only items with a quantity >0

    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.
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    06-10-2009
    Location
    here
    MS-Off Ver
    Excel 2003
    Posts
    36

    Re: Print only items with a quantity >0

    Here is a sample form that I think would be better to print.

    http://officeimages.microsoft.com/i/...2/01022012.gif

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1