+ Reply to Thread
Results 1 to 1 of 1

Auto-populate a worksheet from multiple worksheets, based on unspecified dates.

  1. #1
    Registered User
    Join Date
    09-19-2014
    Location
    Phoenix, Arizona
    MS-Off Ver
    MS Office 2010
    Posts
    1

    Auto-populate a worksheet from multiple worksheets, based on unspecified dates.

    I am attaching my workbook for reference.

    The first five worksheets (with dates) is the information that I manually enter every workday - for each of the 12 indicators in these worksheets. In the following worksheets, I am grouping the previous information by indicator (as found on the date worksheets). On the indicator worksheets, the second page (summary table and charts) are auto-populating, and working great. The first page on these work sheets, however, I am not sure how to organize. This large table is a monthly summary for the 4 people - one for each indicator. Is it possible to have this table automatically fill based on what is manually entered on the Date (original) worksheets? Since the first of the month will be a different day of the week, it's not as simple as just setting up conditional formatting. I would like to have each day of the month, and have the colour code reflect the appropriate day of the month on the date worksheet, plus black fill and no text for weekends.

    I'm not sure if I am being clear enough on my description of the desired end-state.

    I have no problem adding extra helper columns or tables, or anything it would take.

    Thanks in advance for your help!
    Colin
    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. Replies: 0
    Last Post: 03-17-2014, 12:43 PM
  2. Replies: 0
    Last Post: 01-08-2014, 11:01 AM
  3. Replies: 1
    Last Post: 08-20-2013, 06:50 AM
  4. Replies: 2
    Last Post: 07-31-2013, 02:00 PM
  5. auto populate within multiple worksheets
    By r3b3ckah in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-02-2009, 12:52 AM

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