Copying format when using "+'s" between worksheets

[crwiseman]

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

 

[Pete_UK]

A formula can't be used to affect formatting (bold, colours, fonts
etc). If you want these to be exactly the same, then copy the sheet
into the workbook (CTRL-drag is the quickest), then in your copied
sheet you can change all the values and formulae to =Sheet1!cell.

Hope this helps.

Pete