Basically on the Master Report there's a summary section at the top, which rolls all the totals.
Beneath the Summary of Master Report there's the Details sections on the Master Report, which consist All project details. These details are broken up into 11 categories. Th
Under Column A...
Let take a step back…
Master Report has all the links going to it from the Field department reports:
Column D10 (='Field Report Details Y11-12 (G)'!E30) Project Total: $3,000.00
Column E10: Q1, blank
Column F10: Q2, blank
Column G10: Q3, blank
Column H10: Q4, blank
Field Report Details...
I have a report that is linked to cell from many department reports. On the department report there is a section per category: column E with projected total dollar amount ($20,000.00)for the entire year and colmn F has projected quarters (1,2,3,4) the projected totals would be used.
The...