Forum Discussion
Labor and Travel Calculator
Ok SuperUsers I need your help. I have attached a spreadsheet that I use to track travel and labor costs but I need some help. Starting with the Travel Schedule Tab: this tab is where the majori...
chahine This will not work because I use the tables from the Tables tab to use as a drop down on the Calculator tab for the reason. So I need the following to link to the FY_21: the reason, destination and rate.
Also, would it be possible on the calculator tab, when you select the FY, it clears out the reason, the destination and the amounts? I understand this part requires VBA. Let me know.
- can you explain in detail what you need so we can have a look? as i didnt understand fully your requirement
- The things that I need help with are in Bold. On the Calculations tab, when you select the FY, I want the reasons tables to be linked so that only the events that occur in that FY appear and when you select the destination it auto displays the rate for that destination and FY. On the labor tab, for the pivot table, a calculated field can be added to determine the number of hours based on the number of days traveled (excluding holidays and weekends). Then I somehow want it to automatically enter those hours for a specific FY and person to appear in a table just like it's shown in columns K2:Q23. Does this help?
