Forum Discussion

Copper Contributor

Mar 17, 2021

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...

CALCULATOR_SAMPLE.xlsx51 KB

excel

Formulas and Functions

chahine

Iron Contributor

Mar 18, 2021

Sbain2150 please find my solution using indirect so it will be dynamic , i called some tables in the form of FY_21 etc, then used indirect to refer to this, hope this helps

CALCULATOR_SAMPLE.xlsx49 KB

Sbain2150
Copper Contributor
Mar 18, 2021
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.
- Sbain2150
  Copper Contributor
  Mar 19, 2021
  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.
  - chahine
    Iron Contributor
    Mar 20, 2021
    Sbain2150 use conditional formatting, it will clear
Sbain2150
Copper Contributor
Mar 18, 2021
What about the labor part of it?