+ Reply to Thread
Results 1 to 10 of 10

Combining data from multiple sheets into a summary page

  1. #1
    Registered User
    Join Date
    04-27-2016
    Location
    Brooklyn
    MS-Off Ver
    2010
    Posts
    46

    Combining data from multiple sheets into a summary page

    I am trying to a create a workbook in which information regarding a client's medication regimen would be entered into separate sheets for each medication. Each medication would include the med name, dosage, directions and prescriber info with some other info formatted into the sheet. I want to create a summary sheet for the entire regimen which would lay out each med, dosage, direction and prescriber info into columns and allow users of the workbook to delete and add sheets for medications as they are changed.

    Right now I have done this by labeling cells using this formula on the summary page but the problem is this will not be sustainable as meds are added or discontinued (ie sheets deleted or added):

    = IF(med9name= ISBLANK(TRUE), " ",med9name)

    Is this possible?

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,164

    Re: Combining data from multiple sheets into a summary page

    Hi enwoznick,

    Don't do the problem using different worksheets for each medication. Keep all medications in a single table and then filter it (as needed) to show what you need to see. This is a much better method as Excel has great tools dealing with a single table.
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  3. #3
    Registered User
    Join Date
    04-27-2016
    Location
    Brooklyn
    MS-Off Ver
    2010
    Posts
    46

    Re: Combining data from multiple sheets into a summary page

    Thanks for the suggestion but I need the meds to be separated by sheet because the sheets are also going to be printed separated with a table for when they are given to client each day.

  4. #4
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,164

    Re: Combining data from multiple sheets into a summary page

    I hate to give answers that I think are leading to harder problems.

    What if the data was all in a single table and you could then filter the data and use the filtered data to print out the sheets? Rethink having all the data in a single table.. Please?

  5. #5
    Registered User
    Join Date
    04-27-2016
    Location
    Brooklyn
    MS-Off Ver
    2010
    Posts
    46

    Re: Combining data from multiple sheets into a summary page

    I see-- I'm thinking of it backwards!

    So is there a way I can create a table that separates the data as it's entered into separate sheets as medications are added/deleted?
    Last edited by enwoznick; 06-18-2016 at 04:45 PM.

  6. #6
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,164

    Re: Combining data from multiple sheets into a summary page

    Hi enwoznick,

    If you have all your data in a single table you could use AutoFilters to see exactly what the client has. As soon as you go to multiple sheets it makes the problem much harder. Read about AutoFilters at:
    http://www.wikihow.com/Use-AutoFilter-in-MS-Excel
    https://support.office.com/en-us/art...8-35C26E1A51B0

  7. #7
    Registered User
    Join Date
    04-27-2016
    Location
    Brooklyn
    MS-Off Ver
    2010
    Posts
    46

    Re: Combining data from multiple sheets into a summary page

    Thanks. I think I may be trying to do something that is more complicated than excel will allow...

  8. #8
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,164

    Re: Combining data from multiple sheets into a summary page

    Excel can take a single table and break it down into multiple sheets. I find that after doing that awhile the user gets more problems keeping his data straight. What I'm trying to do is show you that by keeping all your data in a single table is a much better method. If you learn a little more about filters and other tools in Excel you will thank me in the long run.

  9. #9
    Registered User
    Join Date
    04-27-2016
    Location
    Brooklyn
    MS-Off Ver
    2010
    Posts
    46

    Re: Combining data from multiple sheets into a summary page

    Yes- but what I am trying to do is have data entered in one place re-appear into a very specific template on another sheet as it's entered which I think may be more complicated than just filtering the data...

  10. #10
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,164

    Re: Combining data from multiple sheets into a summary page

    Hi,

    See this site
    http://www.excel-easy.com/examples/a...d-invoice.html

    The idea is to have a single table that contains all your data and then create a template on another sheet that pulls the data from the larger table so you can print out what is needed.
    If you could attach some sample data of what you have and what it is supposed to print out as, it would be easier to help with this exact question.

+ 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. [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
  2. Replies: 0
    Last Post: 03-17-2015, 12:05 PM
  3. [SOLVED] Combining data across multiple sheets onto one summary sheet
    By dajul73 in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 07-29-2014, 02:10 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. 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
  6. Compiling Select Data from Multiple Worksheets into One Summary Page
    By rockytop80 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-06-2011, 04:17 PM
  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