Forum Discussion
Summary/Overview Page
This was originally posted on another thread. I was advised to go ahead and post here. I have between 10-25 jobs that I am job costing for each month. Is there a simpler way to achieve a summary ...
joeyharris Yes to both requests. The main trick behind having the summary tab more automated is to make sure the tab format for all Vendor Invoices are the same. You can then apply an INDIRECT and CONCATENATE formula combination:
=INDIRECT(CONCATENATE("'",A4,"'!D23")))
I've attached an updated version of your file that you can compare. The Naming structure under your projects should have a perfect match with the tab name to be referenced correctly.
Regarding duplicating the file, wouldn't saving a blank template working template that retains all formulas suffice?