Hi All,

I would appreciate some assistance with the following:

In cell A1 on "sheet 1" I have the name of another sheet within the
same workbook, say "sheet 2".
In cell A2 on "sheet 1" I have the row and column address listed of a
cell on "sheet 2" say "C2".

What I needed is some VBA code that will go to "sheet 1" look-up the
name of another sheet
as well as the cell address on the specified sheet and then move to
the specific address and
then enter a sum formula for a predetermined range.

Does anybody have an idea on how to accomplish the above?

Thanks,

Steve