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

B

brensand

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

Duke Carey

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.
 
L

LTUser54

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
 
Top