you could group the sheets together then when you edit one you will edit
the group

right click on the sheet tabs and select all sheets, if you want to
select various sheets, press ctrl and left click on the sheets you want
to group together


--
davesexcel


------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=540896