Synchronizing two sheets within the same workbook
 

Hi,

I have two sheets within the same workbook, where I would like changes
in one sheet to automatically also change the other sheet.

It is not the entire sheet that should be synchronized, but rather a
part of the sheet. To illustrate you might imagine a square in the
middle of the sheet, which needs to change accordingly with the other
sheet such that if a line is inserted in sheet 1, it is also inserted
in sheet 2.

The import external data function can actually synchronize between
sheets, by updating on the refresh button, I would like a similar
functionality within the workbook.

Thx. in advance.

Lars


--
50pingviner
------------------------------------------------------------------------
50pingviner's Profile: http://www.excelforum.com/member.php...o&userid=29298
View this thread: http://www.excelforum.com/showthread...hreadid=504937