I agree with Niek. While I'm sure it would be possible with some VBA
code associated with Worksheet_Change or Workbook_Change events to do
exactly what you want, in keeping with the KIS principle, the simplest
approach will be one where you designate one of the sheets as the
input/change sheet and the other sheet designated as the mirror sheet
(maybe protected to prevent someone from changing cell formulas on the
mirror sheet).
--
MrShorty
------------------------------------------------------------------------
MrShorty's Profile:
http://www.excelforum.com/member.php...o&userid=22181
View this thread:
http://www.excelforum.com/showthread...hreadid=497307