+ Reply to Thread
Results 1 to 3 of 3

Possible to make a summary page with a list of only true values on a 15 page work book?

  1. #1
    Registered User
    Join Date
    07-13-2015
    Location
    MS
    MS-Off Ver
    2013
    Posts
    10

    Possible to make a summary page with a list of only true values on a 15 page work book?

    Hey guys,
    Ive gotten to a point where im not sure how to do this.
    Ive gone back thru my VB book and online searchs. Im being asked to make a summary page so that if there are any quantities listed in the work book to be put on a single page so no one has to go thru the different pages.
    Ill be back in a few hours to give examples of what id like to do.

    Here is the workbook ive made so far.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,064

    Re: Possible to make a summary page with a list of only true values on a 15 page work book

    Just do a SUM of the relevant Totals (whereever they are) for each worksheet, ie

    in Summary!B20
    =SUM(Consumables!E13,Consumables!K12,Consumables!K23,Consumables!E22,Consumables!E32,Consumables!J32,Consumables!J41)
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

  3. #3
    Registered User
    Join Date
    07-13-2015
    Location
    MS
    MS-Off Ver
    2013
    Posts
    10

    Re: Possible to make a summary page with a list of only true values on a 15 page work book

    I tried to do something similar to that. Boss is wanting everything that has a Quantity greater than 0.1 to be copied to a different sheet.
    If you look on the bolts sheet, you will see 23 sections of different size and material bolts. If there is a way to do a statement where if the quantity is greater than 0.1 then it copy the 4 sections of information, size, quantity, price, subtotal over to a sheet.

    I hope that makes sense.
    Ive been pushing to get a inventory program with a Point of Sale system. But so far this is best we have.

    Thanks for the help!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. sending a single page from a work book
    By Mjh35 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-22-2015, 11:01 AM
  2. [SOLVED] How to get text from multiple work sheet to go on a summary page after calulating values
    By cher062 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-01-2014, 06:30 PM
  3. Formula to pull values in multiple page work book
    By SMOKEYSWORLD in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 11-06-2013, 07:30 PM
  4. trying to make a button on summary page to make new working sheet
    By dbzisme in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 04-07-2013, 05:41 PM
  5. [SOLVED] How to make info from a master sheet go to a page from another book???
    By greenfox74 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 11-28-2012, 02:14 AM
  6. [SOLVED] Publishing part of a work book as a web page probs
    By JK in forum Excel General
    Replies: 0
    Last Post: 02-23-2006, 10:20 AM
  7. Page Breaks for Entire Work Book
    By Steve in forum Excel General
    Replies: 2
    Last Post: 07-12-2005, 07:05 PM

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