Results 1 to 8 of 8

Complex Scheduling in Excel

Threaded View

  1. #1
    Registered User
    Join Date
    04-10-2013
    Location
    Brisbane, Australia
    MS-Off Ver
    Excel for Microsoft 365 version 2402
    Posts
    7

    Complex Scheduling in Excel

    Hi,

    I am hoping someone could help me with the desired outputs here. I am managing training schedules for our program which offer multiple topics for different roles in different locations. I have a file attached here as an example with 2 sheets
    Info - has all the data needed for the desired output
    Schedule - has the desired output (which is currently being filled out manuall) for the Trainee scheduling and the bottom most table for Presenter scheduling.

    My goal is to have a table that's automatically copying from the data entry of trainees and role per location so that it's easy to know which training topics to offer for the month based which roles are joining in the respective locations, as well as table that determines which presenters to invite based on their topic of expertise.

    These are not a fixed format, in fact this is me thinking "manual". If there's a better way to visualize and format these tables so that it's easier to schedule them, I'm very much open to suggestions. Thank you!

    Evee
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. who has a solution for complex scheduling
    By Frans van Huizen in forum Excel General
    Replies: 1
    Last Post: 05-13-2022, 01:57 PM
  2. [SOLVED] Complex scheduling problem using SOLVER
    By D4rwin in forum Excel General
    Replies: 13
    Last Post: 02-09-2021, 08:31 AM
  3. Scheduling in Excel
    By sanjay_dixit04 in forum Excel General
    Replies: 9
    Last Post: 09-02-2019, 10:05 AM
  4. 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
  5. Replies: 3
    Last Post: 09-20-2008, 12:18 AM
  6. [SOLVED] Calculating dates - complex scheduling problem
    By jct in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-22-2006, 04:10 PM
  7. Excel Scheduling
    By will in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-14-2006, 09:30 AM

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