+ Reply to Thread
Results 1 to 5 of 5

Most efficient way to allocate these guest.

  1. #1
    Registered User
    Join Date
    04-11-2017
    Location
    uk
    MS-Off Ver
    mac 2016
    Posts
    8

    Most efficient way to allocate these guest.

    https://drive.google.com/file/d/0B0L...ew?usp=sharing

    Here's the situation: I have about 100 guests to allocate base on the date they apply and the preferences. I need to allocate them base on the date order and then allocate them in their 1st Preferred Area and Room type, and if the rooms are full and that option is no longer avaliable, then I will allocate them to 2nd Preferred Area and Room type.

    what is the best way to do this? thanks for the help in advance.
    Attached Files Attached Files
    Last edited by Excia; 05-05-2017 at 05:12 PM.

  2. #2
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,905

    Re: Most efficient way to allocate these guest.

    Why don't you just attach the file to the post
    In case you don't know how it works I've attached a pdf explaining it.
    Attached Files Attached Files
    ---
    Hans
    "IT" Always crosses your path!
    May the (vba) code be with you... if it isn't; start debugging!
    If you like my answer, Click the * below to say thank-you

  3. #3
    Registered User
    Join Date
    04-11-2017
    Location
    uk
    MS-Off Ver
    mac 2016
    Posts
    8

    Re: Most efficient way to allocate these guest.

    Quote Originally Posted by Keebellah View Post
    Why don't you just attach the file to the post
    In case you don't know how it works I've attached a pdf explaining it.
    oh, i thought it wouldn't matter as long as you can download it through the link. i will try to attach it now.

  4. #4
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,905

    Re: Most efficient way to allocate these guest.

    It's not that is matters but the link is easier from the site, Google drive is not too bad but there are many other sharing sites and those a a p in the a
    I got the file and will look and see if I can help

  5. #5
    Registered User
    Join Date
    04-11-2017
    Location
    uk
    MS-Off Ver
    mac 2016
    Posts
    8

    Re: Most efficient way to allocate these guest.

    Quote Originally Posted by Keebellah View Post
    It's not that is matters but the link is easier from the site, Google drive is not too bad but there are many other sharing sites and those a a p in the a
    I got the file and will look and see if I can help
    my apology. i am really new to this forum but i am trying to look around to get familiarise with the rules.

    thanks in advance for the help. :D

+ 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. Code for guest list attendance
    By jrausch2 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-22-2016, 09:17 AM
  2. Guest Stay Dates Calculator
    By cdeguzman in forum Excel Formulas & Functions
    Replies: 19
    Last Post: 01-24-2014, 12:46 PM
  3. Does anyone know of a template for a wedding guest list?
    By HarborMaster in forum Excel General
    Replies: 0
    Last Post: 05-03-2005, 06:06 PM
  4. How can I set up a guest list counter & tracker?
    By becca in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 04-21-2005, 08:07 PM
  5. Guest List
    By MattRowley in forum Excel General
    Replies: 2
    Last Post: 04-09-2005, 04:41 PM
  6. Attn Moderator: Guest Users
    By mangesh_yadav in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-19-2005, 02:55 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