Results 1 to 2 of 2

Thread: Room planning, Filter and loop help for coloring the right cell

  1. #1
    Neophyte rrhg101's Avatar
    Join Date
    Apr 2019
    Posts
    2
    Articles
    0
    Excel Version
    2019

    Room planning, Filter and loop help for coloring the right cell



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi all,
    I followed room planning tutorial on youtube by Trevor Easton. But il's not complete at all.
    I see in the booking sheet, "morn" and "aft", but if i want to book a new client in the same day, i've an error. I understand that it was a filter for duplicate date. How to make it run if end day in the "morn" and next booking "aft" for a new or add a choice, for more flexible, "morn" or "aft" on start day and end day ?
    I'm in Excel 2019 but in French langage may be you'll have an error, must change langage to french in windows current region (sorry)

    Thks for your help( Sorry for my bad english )

    This is the file for more comprehension.
    Template-Room-Booking (1).xlsm

  2. #2
    Neophyte rrhg101's Avatar
    Join Date
    Apr 2019
    Posts
    2
    Articles
    0
    Excel Version
    2019
    Sorry a wrong file, this is the right

    Template-Room.xlsm

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •