Excel Spreadsheet (NO MACROS) - Tracking spreadsheet for an annual company travel and event
Budget: $30 – $250 USD
Hello,
I would like a spreadsheet that I have changed and improved to track things easier and change data easily every year. I would like all the data sets on a separate tab for the different types of hotels, airports and I want the hotel cost for each room automatically inputting on the spreadsheet when clarifying what type of hotel it is. I want to be able to add the tax amount and daily rates as well and have those automatically inputted. A drop down menu on the main spreadsheet to pick what airport and what room would be good. I do not what the airport linked to a specific price since the prices change so easily. I want that spreadsheet to track budgeted cost then have another tab to track actuals instead of having it all on one sheet. Ignore the trip comparison and hotel 2 tabs and focus on the other 3 and creating a data set tab and moving the actual cost tab from the main attendees tab that is all the way on the far right. I do NOT want any macros on this. Thanks!
I would like a spreadsheet that I have changed and improved to track things easier and change data easily every year. I would like all the data sets on a separate tab for the different types of hotels, airports and I want the hotel cost for each room automatically inputting on the spreadsheet when clarifying what type of hotel it is. I want to be able to add the tax amount and daily rates as well and have those automatically inputted. A drop down menu on the main spreadsheet to pick what airport and what room would be good. I do not what the airport linked to a specific price since the prices change so easily. I want that spreadsheet to track budgeted cost then have another tab to track actuals instead of having it all on one sheet. Ignore the trip comparison and hotel 2 tabs and focus on the other 3 and creating a data set tab and moving the actual cost tab from the main attendees tab that is all the way on the far right. I do NOT want any macros on this. Thanks!