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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Random selections 2
Sorting Macro 4
change multiple links at once 1
Pivot Table Not Behaving as Expected 1
Not sure what to title this???? 8
Do I use a Look up? 4
Why can't I link to a cell that contains a date or a time? 7
Updating data in one Worksheet and propagating it to others 1

Back
Top