I’m ready to create a summary and tally sheet for data spread across a handful of sheets and would appreciate some strategy advice.
The data are my expenditures for various projects I’ve carried out on my house. They’re in one file, about 8 sheets, one sheet per store, and another sheet with half a dozen stores not warranting their own sheet.
Columns are:
Store, Receipt Date, Receipt Index, Description, N, Unit Price, Subtotal, Project, Subproject, Class, Receipt, total, Bank Date, etc…
The data is all hardcoded except for Subtotal, which is formula such as E7*F7
Generally, each sheet has a few cells with totals, such as SUM(G2:G34) in cell G36, and the true sum hardcoded in G37. They should match.