Linking Cell Within Same Book

pcannon · #1 Sep 11, 2006, 09:20 AM

Hello:

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 automaticly update the summary page.

Thanks
PCan

StuMegu · Sep 12, 2006, 05:54 AM

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!



At Ask Me Help Desk you can ask questions in any topic and have them answered for free by our experts. To ask questions or participate in answering them you must register for a free account. By registering you will be able to: Get free answers from experts in any of our 300+ topics. Accept money for answers that you provide. Communicate privately with other members (PM). See fewer ads. Sign Up!