Don -

The suggestions above SHOULD work for you - the best way to do this is like this below.

1) Start on the worksheet page that you want to produce the formula on (say Page2). Go to a cell and type "=" to start the formula. Then, while the formula is activated (will have a blinking border around it), navigate to the other page of the worksheet (say Page2) and click on the Cell that you want to use in your formula. This will pickup that cell from that page and place it in your formula - no problem. Formulas will looks something like the section shown below:

The above reads: Contents of Cell A4 on Sheet1 multiplied by contents of B4 cell on current sheet.... etc

Continue adding arithmetic signs as needed with values from any place on the worksheet - including different pages as you see fit. Use of parenthesis is useful to avoid confusion (to you, not the program)...

I've done this successfully with a work sheet that analyzes RE investment potential: property information all on one page; mortgage schedule an another (for readability). Values on one worksheet page, reference cells on another worksheet page. Works well.

Good luck -
James

__________________
1987 Mercedes 300SDL; SOLD
1985 Mercedes 300D; SOLD
2006 Honda Pilot - wife's ride; 122K;
1995 Toyota Land Cruiser - 3X locked; 182K