Master Sheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
How about just a straigne "Copy and Paste"........record a macro is need be.

Vaya con Dios,
Chuck, CABGx3
 
You can copy the sub values, select the linked values and do edit>paste
specials and select formats
 
Select them and do ctrl + C, then select the values you want to format and
do edit>paste special and select formats
 
Back
Top