I have several workbooks that each has 65-70 worksheets in them and I have to
update and balance them each year at the end of the year. The balancing part
has always been a serious chore and I am trying to find a way to simplify it.
I am currently trying to balance from last year before I have to start this
years!!

Currently, I have a report I pull that tells me the total I need to balance
back to, and I keep it in Excel also. I have been linking the cells from
each sheet back to this report sheet but wanted to see if there is a formula
or function I can use that will pull the figure from one cell in each
spreadsheet to the report sheet where I can compare and determine which
sheets do not match as my totals are not matching.

I entered a simple linked formula, but to enter that formula into each cell
will take entirely too long. Copying does not work, it simply pulls the
first sheet total, all the way down the report sheet. Changing the formula
for each line is also very time consuming. I tried a true/false formula, but
with the same problem. The first one works fine, but the copies reference
the first sheet and not the following sheets.

Is there anything I can do to speed this up and make it easier to find where
I am out of balance?


--
G

custom forms created
bookkeeping services
budget consulting

for quotes