Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
set up a link that updates page one from all other page entries?
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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
set up a link that updates page one from all other page entries?
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is there away to link something on one page to another? | Excel Discussion (Misc queries) | |||
Remove link fr a column of entries | Excel Discussion (Misc queries) | |||
Remove link fr a column of entries | Excel Discussion (Misc queries) | |||
Remove link fr a column of entries | Excel Discussion (Misc queries) | |||
How do Icreate link from page of contents to sheets in workbook? | Excel Discussion (Misc queries) |