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