Copying format when using "+'s" between worksheets
 

Hello,

How do I preserve the same formatting ie: $ signs when using the
formula "+" between worksheet pages? I want to preserve the dynamic
functionality so if someone inserts or changes data on the "DATA"
sheet, the "DAILY" subsheets also change. If I COPY the data from the
DATA sheet and someone changes the DATA, the DAILY sheets won't get
updated. If I use the "+ cell from another sheet", the data changes
will sync dynamically but the formatting gets lost.

Thanks,

CRW


--
crwiseman
------------------------------------------------------------------------
crwiseman's Profile: http://www.excelforum.com/member.php...o&userid=32758
View this thread: http://www.excelforum.com/showthread...hreadid=525901