Could we go back to this problem? As you suggested, I inserted column V in table 1 indicating if the major account is Sundry or Column. I have also simplified the location of Sundry columns in the CHDJ sheet. What's the formula for putting the sundry major accounts of each check in the CHDJ? Please help me find peace about this. I've tried several formulas but with unsatisfactory result. Problem areas were painted yellow.
|