So I have done work with formulas on other projects but this one i havnt been able to figure out. I have a table where i am going to keep track of equipment hours and another where i keep track of fuel used.
For the hours table i will add a new column for each day with the equipment hours to track how many hours that machine operated that day but i need to have 1 column that reports the last hours input. I know that i can put a “Ceiling” formula in but that would require modifying the formula to add a new column each day and after awhile that will get stupid. I would need one column that would take the highest number of all columns.
For the Fuel table, i will be adding a new column for everyday to track fuel consumption. This would be easy using the Sum formula but just like the Ceiling formula, i would have to modify the formula everyday, adding a new column for it to include. I would need one column that could be updated with the sum of all columns related to fuel.
Is there anyway to do this without have ridiculous formulas? I am assuming i would need to do some form of macro but i have no clue how to write that out. Any help is much appreciated.