Grouping worksheets in Excel

[ScubaStevo]

Hi

How can I groupo multiple worksheets together so when i change something in one cell, the corresponding cells in the other worksheets automatically change?

Thanks

Steve

 

[KenWright]

Click on one sheet, hold down Shift and then click on another tab. This is OK for editing, but I wouldn't suggest trying to leave a file like this so that it always happened. All sorts of potential to louse things up if you're not careful.

Regards
Ken............

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
----------------------------------------------------------------------------