Actually, found an issue, the D column formula needs to be changed a bit...
Formula:
=IF(ROW()-1>MATCH("Totals",Sheet1!$A:$A,0)-1,"",IF(INDEX(Sheet1!$A2:$U2,MATCH(RIGHT(CELL("filename",$A$1),LEN(CELL("filename",$A$1))-FIND("]",CELL("filename",$A$1))),Sheet1!$A$1:$U$1,0))="","",Sheet1!E2))
The the BOLD RED letter (at the end of the formula) needs to be changed to the following on each sheet
For Ch sheet, Change it to I
For Di sheet, Change it to J
For Ni sheet, Change it to K
For Po sheet, Change it to M
Discovered that some of the Debits are split between 2 or more departments, which I would not have thought about, except that iI was playing around with FDibbins PT solution, and noticed the irregularities
Bookmarks