copy cell format?

L

Ltat42a

I have two worksheets. One I use to insert data, the other to summariz
the data I entered. On the data sheet, I have a few items that ar
bold/red.

I'm using ='data'!b2 to copy the cell contents from the data sheet int
the summary sheet, it copies the content, but not the forma
(bold/red).
How can I correct this?

J
 
D

Dave Peterson

Formulas can only return values--not formats.

I think copy|paste special|formats either manually or via a macro is the way to
go.

(If you need a macro, record one when you do it manually.)
 
Top