+ Reply to Thread
Results 1 to 6 of 6

testing scheduling sheet to show only what is due this month

  1. #1
    Registered User
    Join Date
    12-27-2019
    Location
    Winnipeg, Canada
    MS-Off Ver
    2016
    Posts
    4

    testing scheduling sheet to show only what is due this month

    I have a workbook for tracking testing schedules.
    It has 1 tab that I edit when I do a test, and another that populates when the next on will be due.
    What I would like is to then have a third tab that only shows what will be due in the current month.


    What would be really great would be to be able to export to a calendar, but not holding my breath on that just yet
    Attached Files Attached Files
    Last edited by maugris; 12-27-2019 at 04:43 PM. Reason: updated spreadsheet

  2. #2
    Forum Contributor
    Join Date
    11-05-2019
    Location
    Tiki Island, TX
    MS-Off Ver
    Office 365
    Posts
    168

    Re: testing scheduling sheet to show only what is due this month

    The key to this is to go to the Data tab and make both of your input sheets into tables connection only. Then using the data queries & connections option you can now edit those tables. Unpivot the columns on each of the tables from the transform tab when you edit the tables. Then merge the tables together and sort them to get your table. Example attached.
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    12-27-2019
    Location
    Winnipeg, Canada
    MS-Off Ver
    2016
    Posts
    4

    Re: testing scheduling sheet to show only what is due this month

    Perfect! Thank you so much.

  4. #4
    Registered User
    Join Date
    12-27-2019
    Location
    Winnipeg, Canada
    MS-Off Ver
    2016
    Posts
    4

    Re: testing scheduling sheet to show only what is due this month

    I have upgraded this sheet with a calendar. Thanks to another tread and work done by Pete_UK.

    I was wondering if there was a way to automate the refresh on the List tab?
    Attached Files Attached Files
    Last edited by maugris; 12-29-2019 at 06:17 PM.

  5. #5
    Registered User
    Join Date
    12-27-2019
    Location
    Winnipeg, Canada
    MS-Off Ver
    2016
    Posts
    4

    Re: testing scheduling sheet to show only what is due this month

    I just have a couple more questions. They all pertain to a calendar made by Pete_UK

    On months that don't use all the weekdays, how do I make it complete borders?

    I was able to make paydays show as a task in the calendar, but I would like to have the date change to green background if that's possible.
    Attached Files Attached Files
    Last edited by maugris; 12-31-2019 at 02:49 PM.

  6. #6
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,423

    Re: testing scheduling sheet to show only what is due this month

    I would like to have the date change to green background if that's possible
    Try the following formula as a conditional formatting rule applied to B4:M40 =AND(ISNUMBER(B4),B6="Payday")
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ 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] Testing two dates against a month and year
    By BlissC in forum Excel General
    Replies: 3
    Last Post: 03-22-2018, 05:11 PM
  2. [SOLVED] Random Testing by Month
    By P Hawk in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 11-30-2015, 12:16 AM
  3. [SOLVED] Show employee data from another sheet for current month
    By earthandbody in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-06-2015, 10:39 AM
  4. Show employee data from another sheet for current month
    By earthandbody in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-11-2015, 08:09 AM
  5. Show employee data from another sheet for current month
    By earthandbody in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-09-2015, 03:29 PM
  6. Scheduling: Calendar style scheduling based on scheduling list
    By denkatprieto in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 12-19-2012, 11:10 AM
  7. [SOLVED] Testing whether a date falls within a certain month.
    By jngu007 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-09-2012, 06:53 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