Thanks, but I'm actually trying to create a template that will allow me
to enter data in a master sheet, which will be mirrored in all
subsequent sheets. Since I want the data to be duplicated over ten
sheets, I don't want to copy and paste it individually. So far, I'm
only able to copy the data, but the cell format is set by each
individual cell. Is there a way to set the cells to "follow" the
format of a cell in the master sheet, regardless of what kind of
changes I make?


--
careyc
------------------------------------------------------------------------
careyc's Profile: http://www.excelforum.com/member.php...o&userid=26064
View this thread: http://www.excelforum.com/showthread...hreadid=476778