Thank you Gord, your answer was all I needed to take care of the problem in a
quick, easy manner.

"Gord Dibben" wrote:

Two takes on one post..................how rare<g

OP states "two pages on a worksheet"

The merged titles and freeze panes makes sense if that's the case.

Row 1 is titles............row 51 is the same titles instead of freezing row 1

Might be better if OP had just one row of titles at top and used "rows to repeat
at top" when printing the two pages.

Gord

On Sat, 2 Jun 2007 13:22:00 -0700, ShaneDevenshire
wrote:

Hi,

If the previous answer works, fine, if not could you please show us what
your data looks like. Based on the limited description the answer would be
more like =Sheet2!A502+Sheet3!A100.

Now if the cells in both sheets are the same and the sheets are contiguous
then:

=SUM(Sheet2:Sheet3!A50) might be another solution.

But freeze panes and merged titles don't appear to be relavant to the
question as stated.