+ Reply to Thread
Results 1 to 3 of 3

Help Making a Summary Page of Multiple Sheets been Categorize by a ID number.

  1. #1
    Registered User
    Join Date
    02-12-2017
    Location
    usa
    MS-Off Ver
    2010
    Posts
    2

    Help Making a Summary Page of Multiple Sheets been Categorize by a ID number.

    I need to create a summary page that will grab data from all sheet if the id number match it will only create one row in the summary page but add the base amount of each sheet and place the result on column name total investment for that id. I would like for this to update it self automatically every time i add a new sheet or add a new row to any of the sheets. here is a example of the workbook.

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,598

    Re: Help Making a Summary Page of Multiple Sheets been Categorize by a ID number.

    The workbook has not been attached, but your description makes little sense without it.

    To do this, click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and then on Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post.

    Please Note that the Paperclip icon does not work.

    Hope this helps.

    Pete

  3. #3
    Registered User
    Join Date
    02-12-2017
    Location
    usa
    MS-Off Ver
    2010
    Posts
    2

    Re: Help Making a Summary Page of Multiple Sheets been Categorize by a ID number.

    Sorry about that. The file was too big so i had to compress it.
    Attached Files Attached Files

+ 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. Combining data from multiple sheets into a summary page
    By enwoznick in forum Excel General
    Replies: 9
    Last Post: 06-18-2016, 05:17 PM
  2. [SOLVED] Excel Links to Summary Page from Multiple Sheets
    By macro12 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-05-2015, 11:45 AM
  3. Replies: 0
    Last Post: 03-17-2015, 12:05 PM
  4. Due date summary page for multiple sheets
    By missd in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-30-2013, 08:48 AM
  5. Making a value sensitive summary page for quoting materials
    By mkerfoot in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-10-2013, 09:50 AM
  6. Pulling data from Multiple sheets into a summary page
    By biz07 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-19-2012, 10:39 AM
  7. Ranking scores/names from multiple sheets on summary page
    By Graphire in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 11-18-2008, 08:08 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