How to pass font color changes between worksheets 1

[rji1124]

Hi... we are using Excel 2003... I was wondering if there was a way to carry font characteristics between cells and worksheets e.g.,
I have 2 worksheets in the same workbook... (A & B)
Worksheet A is an 'overview' sheet and worksheet B is a 'Detail sheet'...

I have cells on A that are pulled from B. On the B sheet (Detail), I change the font color of some cells to Red to show that field has changed - I would like to red color to show up on the A sheet automatically (without having to manually alter the A font color..

Is this possible???

Thanks

 

[SkipVought]

Hi,

"I change the font color of some cells to Red ..."

How? There is more than ONE way.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[rji1124]

I do it a couple of different ways - format cells, change color from automatic to red.... the Excel toolbar has a font change pulldown for color...

 

[SkipVought]

If you Copy 'n' Paste, you also get fomatting information. Turn on your macro recorder.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[chilly442]

Use paste special and select "all."
Then put it behind a button.

Sub Macro3()
'
' Macro3 Macro
' Macro recorded 09/05/2008 by CSU
Range("A1").Select
Selection.Copy
Sheets("Sheet2").Select
Range("A1").Select
Selection.PasteSpecial Paste:=xlPasteAll, Operation:=xlNone, SkipBlanks:= _
False, Transpose:=False
End Sub

Hope that helps.

 

[rji1124]

Thanks chilly442 - that was exellent advice! I need to now figure out how to do this in blocks of data from one sheet to another... reading about multiple cells and areas.
Thanks for the help...

 

[chilly442]

You can use the same code as above but insert a range.

Range("A1:B100").Select
Selection.Copy
Sheets("Sheet2").Select
Range("A1:B100").Select
Selection.PasteSpecial Paste:=xlPasteAll, Operation:=xlNone, SkipBlanks:= _
False, Transpose:=False

See if that works.

Chilly442

 

[SkipVought]

How would you describe the various ranges that you want to copy?


Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]