I have 2 files where I generate reports for others. They both work the same
way in terms of setup and purpose. What I do is enter information onto the
worksheets and run subtotal reports for each sheet using a macro in
PERSONAL.xls. What I would like to do is pick up the subtotals from all
sheets for certain cells containing matching criteria. I tried a SUMIF across
the board but, because my criteria was not present in all sheets considered,
I got an error. I would like to pick up the subtotals as values and sum them
up by account number.

Say I have entries for account 123. The subtotal wizard kicks out a summary
cell called 123 Total. What I would like is to have a command where if the
left of the 123 Total = the cell in my master sheet and the right of the 123
Total = "Total", pick up the cell I need using the Offset line. I need to
stick this in a procedure as well. Thanks (hope this is enough info!)
--
I am running on Excel 2003, unless otherwise stated. Please rate posts so we
know when we have answered your questions. Thanks.

Please ignore this post, as I have found a workaround to get my desired
results.