+ Reply to Thread
Results 1 to 2 of 2

Populate calendar and summary

  1. #1
    Registered User
    Join Date
    04-10-2016
    Location
    Christchurch, New Zealand
    MS-Off Ver
    2010
    Posts
    11

    Populate calendar and summary

    HI all

    I'm looking through various threads, but thought i'd post - in case anyone sees a better way for me to get what i'm after.

    I'm needing to create a register of leave - each site (location) will have their own register - but then the senior leadership team needs an overall look at the leave.

    The Senior team - don't necessarily need names, however they do need to know a summary of how much leave is taken at each site by day / week / month.


    On the attached - can the datatable automatically populate details into the LeaveCal2 tab?

    I'm trying to future proof this, hence asking before going too much further - as i'm sure once i get this working the management team will want more details added!
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    05-03-2020
    Location
    Surabaya, Indonesia
    MS-Off Ver
    2016
    Posts
    21

    Re: Populate calendar and summary

    Quote Originally Posted by annaisakiwi View Post
    HI all

    I'm looking through various threads, but thought i'd post - in case anyone sees a better way for me to get what i'm after.

    I'm needing to create a register of leave - each site (location) will have their own register - but then the senior leadership team needs an overall look at the leave.

    The Senior team - don't necessarily need names, however they do need to know a summary of how much leave is taken at each site by day / week / month.


    On the attached - can the datatable automatically populate details into the LeaveCal2 tab?

    I'm trying to future proof this, hence asking before going too much further - as i'm sure once i get this working the management team will want more details added!

    Hi annaisakiwi,

    IMHO, it's not the best choice to make LeaveCalendar sheet as Data Structure.
    Because it'll make you a headache to scroll to the right once you reach 20-30 employees or even more (no Columns limit).
    And it'll not support for more than one location because one sheet only for one location, since you have 9 Locations then you'll have to build 9 LeaveCalendar.
    So it's more likely used as Reporting Form.
    Maybe experts, gurus, masters and seniors have another better solution or suggestion for you.

    Well, this is my suggestion for you.....
    As I said before, because LeaveCalendar not suitable for Data Structure, which is Datatable sheet is the most suitable one.
    So you have to fill Datatable manually and carefully. Or if your Data still formatted like in the LeaveCalendar, you may use Excel built-in filter function then copy paste values one by one names.

    Once the Datatable created then we'll use LeaveCal2 and LeaveCalendar as Reporting Form.
    I've made 2 sheets for each reports, by Formula and by Pivot Table. And some adjustment too for your Data structure to fulfill your Calendar Style Report.

    For more details, you may check on my excel file attachment if you wish.
    Let me know if you have any question.
    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. Calendar/Scheduling Sheet Summary
    By mooshoo in forum Excel General
    Replies: 3
    Last Post: 05-02-2018, 01:49 AM
  2. [SOLVED] Populate Summary Sheet
    By ExcelSpreads in forum Excel General
    Replies: 3
    Last Post: 04-20-2016, 11:31 PM
  3. [SOLVED] Populate data for Summary
    By omegaboost in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-02-2016, 03:12 AM
  4. [SOLVED] Assistance with Summary of Employee Non Project Calendar
    By Cidona in forum Excel - New Users/Basics
    Replies: 10
    Last Post: 01-11-2015, 05:18 PM
  5. Replies: 2
    Last Post: 04-01-2014, 09:24 PM
  6. Excel 2007 : Summary for calendar
    By darkhangelsk in forum Excel General
    Replies: 0
    Last Post: 09-22-2011, 11:00 AM
  7. Replies: 0
    Last Post: 04-25-2011, 04:28 PM

Tags for this Thread

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