+ Reply to Thread
Results 1 to 4 of 4

Best way to cross populate multiple arrays based on data entry into a single array?

  1. #1
    Forum Contributor
    Join Date
    07-25-2012
    Location
    San Antonio, Texas
    MS-Off Ver
    Excel 2010
    Posts
    142

    Best way to cross populate multiple arrays based on data entry into a single array?

    My user is looking to have a schedule created using 4 seperate arrays. The goal is to fill in information into one or two arrays and have the main array autofill based on these entries. The schedule itself is of a large group of employees and three seperate groups of trainers. Each day, a trainee is scheduled with a trainer and for a specific time. Within the excel demo I've enclosed, I've included some more descriptions and a completed day on Saturday. I'd love to be able to accomplish this without macros but am open to any and all help. I don't know if it'd have to be a lookup or match or an if, then statement.

    I tried finding something like it online but either nobody's ever thought of it, or they were smart enough to figure it out on their own. I'm not and I'm horrible at syntax, so again, any and all help is welcomed and greatly appreciated.

    Schedule Demo.xlsx
    -Orestees

  2. #2
    Forum Contributor
    Join Date
    07-25-2012
    Location
    San Antonio, Texas
    MS-Off Ver
    Excel 2010
    Posts
    142

    Re: Best way to cross populate multiple arrays based on data entry into a single array?

    Bueller Bump. . .

  3. #3
    Forum Contributor
    Join Date
    07-25-2012
    Location
    San Antonio, Texas
    MS-Off Ver
    Excel 2010
    Posts
    142

    Re: Best way to cross populate multiple arrays based on data entry into a single array?

    Getting kinda desperate here. Anyone know how this can be accomplished? I'm surprised I couldn't find anything covering this topic anywhere but I guess there's always a first. If I need to clarify anything, please let me know.

    Thanks again *crosses fingers*

  4. #4
    Forum Contributor
    Join Date
    07-25-2012
    Location
    San Antonio, Texas
    MS-Off Ver
    Excel 2010
    Posts
    142

    Re: Best way to cross populate multiple arrays based on data entry into a single array?

    In the past, this forum has been a great source of help for me and I thank you all for that.

    I'm not sure if; I didn't explain my issue well enough, nobody cares, nobody knows, or what.

    Again, I really appreciate any help I can get, or guidance.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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