View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Gareth R Gareth R is offline
external usenet poster
 
Posts: 1
Default Automatic updating between worksheets

Hi,
I have 3 worksheets with each worksheet having a the same data as the
previous one but in finer detail, ie. Sheet 1 is the Master Timetable, sheet
2 has only the Timetable of a select individuals from the Master, and sheet 3
has only a select few timeslots of the select individuals from Sheet 2.
How do I go about linking in all 3 worksheets so that if I make a change to
worksheet 1,2 or 3, they automatically update the other worksheets ie, any
changes to 2 or 3 will update the master Diary?

Any advice would be greatly appreciated.

Regards.