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



"Cam1234" wrote:

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

You can copy the sub values, select the linked values and do editpaste
specials and select formats


--
Regards,

Peo Sjoblom



"Cam1234" wrote in message
...
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 do I copy the sub values and select the linked values?

Thanks!

"Peo Sjoblom" wrote:

You can copy the sub values, select the linked values and do editpaste
specials and select formats


--
Regards,

Peo Sjoblom



"Cam1234" wrote in message
...
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

Select them and do ctrl + C, then select the values you want to format and
do editpaste special and select formats


--
Regards,

Peo Sjoblom



"Cam1234" wrote in message
...
how do I copy the sub values and select the linked values?

Thanks!

"Peo Sjoblom" wrote:

You can copy the sub values, select the linked values and do editpaste
specials and select formats


--
Regards,

Peo Sjoblom



"Cam1234" wrote in message
...
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