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

Auto update of data in multiple worlsheets
 

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

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

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.