I own a small hotel and would like to manage just the daily, weekly or monthly rental income. I already have template, with room numbers, on the column side, calender shows the days occupied, on rows side. I need someone write macros, so I can just open a table, enter new or same tenant's name, staying period, dates, room rate, how much paid, how much is due, calender day colors will change if it is not paid in full. Also give me a few reports.
For every new booking, I would open the table and all the entries go in the my occupancy calender automatically.
20 freelancers are bidding on average $222 for this job
Hello, i have expertise in Excel and VBA. If you are interested in my bid, please contact me. I have some questions regarding the template. Thank You. Best Regards.
We are a team of 2 having a vast experience on excel VBA (macro) scripting. Looking forward to work with you. thanks !!! Please have a look at our message in your PMB.
I'm a engineer and I also have a MBA degree. During my academic and professional career I use excel every day. I understand what you need and I'm able to do the work. Regards, Liliana