+ Reply to Thread
Results 1 to 3 of 3

Getting Dates to Populate on a Total Summaries Page

  1. #1
    Registered User
    Join Date
    05-13-2014
    MS-Off Ver
    Excel 2010
    Posts
    33

    Getting Dates to Populate on a Total Summaries Page

    Hey guys,

    Slightly odd request,

    I have a total summary page, which sums up a bunch of data for around 2 weeks. Is there any way to have the corresponding dates appear on the summary?

    Ive attached a example spreadsheet, showing a basic total summary, and the quantity, the highlighted red section is what I would like to appear if possible

    Any ideas?
    Attached Files Attached Files

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,053

    Re: Getting Dates to Populate on a Total Summaries Page

    This won't be difficult. However, unless you show us where the date information is stored on the source sheets and how it is stored, it is impossible for us to help. you need to post an example spreadsheet (no confidential information) showing all the possible combinations of data sources.
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

  3. #3
    Registered User
    Join Date
    05-13-2014
    MS-Off Ver
    Excel 2010
    Posts
    33

    Re: Getting Dates to Populate on a Total Summaries Page

    I attached the current spreadsheet I am working on,

    On the "Total Project Summary" tab, you can see I have 13 weeks indexed, Row 2 are all the dates as they appear and Rows 3 - and on index all the values from each working week

    So its similar to the example I posted, but see if this helps
    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. Removing Existing Page Breaks and Inserting a Page Break every third Total Line
    By Kalvas in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-17-2013, 05:12 AM
  2. Get total pages per sheet and set page numbers in page footer by formula
    By Snoopy2003 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-13-2013, 04:00 PM
  3. unique counting and total summaries - 2 requests
    By mahesh007 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 01-29-2013, 01:45 PM
  4. Yes/no drop down list needs to populate a contents page with matching page numbers
    By limebaish in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-19-2013, 02:46 PM
  5. Challenge: Charting weekly summaries, monthly summaries
    By kolfinna in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-19-2007, 07:28 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