Excel Newbie here, and all I really want to do is get totals for how much money each person spent each month, on fuel and vehicle maintenance, and have it separated out by job paycode so that the correct departments get billed for it.
I have a workbook being used as a Vehicle Maintenance...
I use 3D references to sum up data from a number of sheets.
The quite basic formula is along the lines of:
=SUM('Data ->:<- Data'!A1)
with 'Data ->' and '<- Data' being the two delimiter sheets.
The formula works fine, except that it does not update automatically.
If I change one of my data...