Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto update of data in multiple worlsheets
Is there a simple way to have two or more data worksheets that are
merely different sorts of a master sheet and be able to update the data in the master and have it automaticallly updated in the sorted sheets?. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto update of data in multiple worlsheets
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto update of data in multiple worlsheets
Stopher wrote: wrote: Is there a simple way to have two or more data worksheets that are merely different sorts of a master sheet and be able to update the data in the master and have it automaticallly updated in the sorted sheets?. Have the sorted sheets reference the Masters, you will get a message when you open the sorted sheets along the lines of this shhet contains links to other worksheets would you like to update. This would be the simplest way. Stopher How does one create the references? LarCrow |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto update of data in multiple worlsheets
copy data from the master onto your sort sheets. The paste should put
the link in automatically. If you look in the formual bar you will see this. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
auto update to multiple worksheets | Excel Discussion (Misc queries) | |||
Consolidate multiple lists, with auto-update | Excel Discussion (Misc queries) | |||
Help - Auto update from multiple spreadsheets | Excel Worksheet Functions | |||
Help - Auto update from multiple spreadsheets | Excel Discussion (Misc queries) | |||
how to update data on sheet1 and have it auto update on sheet2 | Excel Programming |