ExcelBanter - View Single Post - Auto update of data in multiple worlsheets

Stopher

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