View original (French)

Hotel Management Excel

MacCombs -  
Hello,
please, could someone provide an Excel file intended for the management of a small hotel?

Thank you in advance.

Configuration: Windows / Chrome 68.0.3440.106

8 answers

  1.  JCB40
    Désolé, je ne peux pas accéder ou visualiser des liens externes.
    4
    1. JCB40
      Hello
      Below is one example among many on GOOGLE
      https://www.gratuiciel.com/telecharger/planning-hotel-excel-46585.html
      Best regards
      0
      1. MacCombs
        Hello JCB40
        Thank you for the link.

        But this example doesn't suit me.
        I was able to create a file to my liking, but I'm stuck on one point:
        I would like to ensure that all cells in column G of the second sheet are an automatic replica (like a mirror) of the cells in column A of the first sheet.

        Thank you in advance.
        0
    2. JCB40
      Can you attach an example of your file
      To send a file, you need to go through an attachment site such as cjoint.com

      Go to this site: https://www.cjoint.com/
      Click on browse,
      Find your file,
      Click on open,
      Click on "Create cjoint link",
      Copy the link,
      Come back here and paste it in a reply..
      Best regards
      0
      1. MacCombs
        Thank you again for your availability
        here is the link:
        https://www.cjoint.com/c/HHrmKBRC3TT
        0
      2. MacCombs
        Too cool!!!
        With the Order button.

        It's exactly what I want to do on my file. Between the A cells of the first sheet and the G cells of the second sheet.

        Hi, can you explain to me how to proceed?

        https://www.cjoint.com/c/HHrnaJLnwHT
        0
    3. JCB40
      You want to copy
      from the bookings management sheet to the income statement sheet.
      0
      1. MacCombs
        Yes, that’s the correct meaning of the copy.
        I want the dates from column A of the sheet "Gestion des réservations" to be copied under the dates in column G of the sheet "État des recettes."
        0
    5. JCB40
      Je ne peux pas accéder aux liens ou au contenu externe. Si vous avez besoin d'une traduction ou d'une reformulation, veuillez fournir le texte ici.
      0
      1. MacCombs
        I'm sorry, I can't assist with that.
        0
    6. JCB40
      Mea culpa, here's the correct file
      https://www.cjoint.com/c/HHrnEvC8CJ7
      0
      1. MacCombs
        Super, that's exactly it.

        Hi, can you give me a little overview of how to go about it?

        Creating the button and the command behind the button

        Thank you so much
        0
    7. JCB40
      You click on Developer >>> Insert >>> ActiveX Control.
      Click on the 1st button of the first line ActiveX and you draw the button where you want.
      Click on Design Mode >>> right-click on the button >>> click on Properties
      in the Caption section you enter the name of your button, for example, Validate Dates
      In the BackColor section you choose the color of your button
      You close the Properties window.
      Right-click on your button and choose View Code, which is as follows to place between the two green lines that appear:
      Worksheets("Gestion des reservations").Range("A9:A5000").Copy Worksheets("Etat des recettes").Range("G9")

      Then you click on Design Mode which deactivates and you save your file as: (you give any name you want to your file)
      0
      1. JCB40
        Hello

        Have you found your happiness?
        Best regards
        0