Automatically update data across worksheets
 

I have an Excel worksheet containing 4 worksheets. The main data is in
Sheet 1. I need to update certain cells in Sheet 1 regularly and those
cells are repeated in sheets 2,3,and 4. My question is can I update the
whole lot automatically to save having to open each worksheet every
time?




--
Lancashire Lass

Automatically update data across worksheets
 

One way:

In the repeated cells, use

=Sheet1!A1

In article ,
Lancashire Lass wrote:

I have an Excel worksheet containing 4 worksheets. The main data is in
Sheet 1. I need to update certain cells in Sheet 1 regularly and those
cells are repeated in sheets 2,3,and 4. My question is can I update the
whole lot automatically to save having to open each worksheet every
time?