View original (French)

Hotel Management Excel

MacCombs -  
JCB40 Posted messages 3058 Registration date   Status Member Last intervention   -
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 Posted messages 3058 Registration date   Status Member Last intervention   479
     
    Désolé, je ne peux pas accéder ou visualiser des liens externes.
    4
  2. JCB40 Posted messages 3058 Registration date   Status Member Last intervention   479
     
    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
  3. JCB40 Posted messages 3058 Registration date   Status Member Last intervention   479
     
    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
  4. JCB40 Posted messages 3058 Registration date   Status Member Last intervention   479
     
    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
  6. JCB40 Posted messages 3058 Registration date   Status Member Last intervention   479
     
    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
  7. JCB40 Posted messages 3058 Registration date   Status Member Last intervention   479
     
    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
  8. JCB40 Posted messages 3058 Registration date   Status Member Last intervention   479
     
    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
  9. JCB40 Posted messages 3058 Registration date   Status Member Last intervention   479
     
    Hello

    Have you found your happiness?
    Best regards
    0