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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

brensand - 17 May 2006 17:30 GMT

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?

Reply to this Message

Duke Carey - 17 May 2006 20:02 GMT

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.

> 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?

Reply to this Message

LTUser54 - 17 May 2006 20:19 GMT

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

paste SPECIAL paste Link (it's a check box at the bottom of the past
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 nee
more explicit instructions

Reply to this Message