Hello::confused:

How do I link cells in worksheet to cells in another worksheet within the same book?

When editing data in a worksheet, I would like for it to automatically update the summary page.

Thanks
PCan

=celladdress

For example, if you want the value in cell Sheet1!A1 to show up in cell Sheet2!A1, just type = and the cell address.

You can also type "=" in the cell and then click the cell that you want to reference. Just type = on the summary page, then click the sheet with the info on it and then the cell and press return. Go back to the original cell and it should reference the source using the format that Scott described.

Good Luck!