I posted a similar post in the MACRO subforum asking for macros to assist with this but I was wondering if it could also be down by a formula.

Anyway I have an excel workbook with about 200 worksheets. Every workseheet contains a report like this:


Capture1.PNG


For every value in Columns E,F,G,or J there would need to be an entry in a row in this format: Date-GL-Fund#-Department-project-$amount. There would then need to be an offsetting entry. This template would populate like this, notice that the signs are reversed:

Capture2.PNG

In the end everything zeros out.

There are about 200 worksheets like this. The number of records will vary and the Fund # will be different in each fund.

Does anyone have any suggestions, resources, functions, or formulas that would be useful?