Master Sheet

C

Cam1234

I'm trying to create a master sheet from 3 sub sheets, and all I want is the
exact entry in a sub sheet to display in the master sheet. The problem with
using the IF function is that it does not copy any formatting such as font or
background color. Is there anyway to tell excel to put the exact contents
from row 4 to row 54 in a sub sheet to, say, row 34 to 84 in the master sheet
- including formatting?

Thanks for you help!

Cam
 
C

CLR

How about just a straigne "Copy and Paste"........record a macro is need be.

Vaya con Dios,
Chuck, CABGx3
 
P

Peo Sjoblom

You can copy the sub values, select the linked values and do edit>paste
specials and select formats
 
P

Peo Sjoblom

Select them and do ctrl + C, then select the values you want to format and
do edit>paste special and select formats
 
Top