set up a link that updates page one from all other page entries?

In an Excel workbook the first page includes info from 20 counties. The other
pages in the workbook contain info from each of the individual counties. When
info is entered into any of the individual counties I would like for the info
to be automatically updated in the worksheet containing all counties. How do
I do this?

The conventional way of doing this is to keep ALL THE DATA in a single sheet,
then using filters or pivot tables to generate a report/analysis for a single
county. If you accept that thesis, then you are approaching this backwards.

"brensand" wrote:

In an Excel workbook the first page includes info from 20 counties. The other
pages in the workbook contain info from each of the individual counties. When
info is entered into any of the individual counties I would like for the info
to be automatically updated in the worksheet containing all counties. How do
I do this?

just update the info for the individual countries, then copy the cell
you wnat info FROM and

paste SPECIAL paste Link (it's a check box at the bottom of the paste
special popup, then paste it to the cell you want updated

the cell will read like this: =Sheet1!$C$15 when you mouseover it

hope these instructions are understandable - let me know if you need
more explicit instructions.


--
LTUser54
------------------------------------------------------------------------
LTUser54's Profile: http://www.excelforum.com/member.php...o&userid=33459
View this thread: http://www.excelforum.com/showthread...hreadid=542990