Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Linking cell format across worksheets
I want to link cells across worksheets so that if I make a change to the cell
format (in this cae, background colour) in cell 1A of sheet 1, the same change is automatically updated for the same cell in sheet 2. I have access to both Excel 2003 and 2007. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Linking cell format across worksheets
You can link a format from a cell to a picture, but not to another cell. You
can alway transfer the format with a macro, however. -- Gary''s Student - gsnu200851 "PiL" wrote: I want to link cells across worksheets so that if I make a change to the cell format (in this cae, background colour) in cell 1A of sheet 1, the same change is automatically updated for the same cell in sheet 2. I have access to both Excel 2003 and 2007. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Linking cell format across worksheets
Assuming your data is in cols A & B, try this small macro:
Sub Columnize() n = Cells(Rows.Count, "A").End(xlUp).Row k = 1 j = 1 For I = 1 To n Set r = Range(Cells(I, 1), Cells(I, 2)) r.Copy Cells(k, j) k = k + 1 If k = 201 Then k = 1 j = j + 2 End If Next Range("A201:B" & n).Clear End Sub -- Gary''s Student - gsnu200851 "PiL" wrote: I want to link cells across worksheets so that if I make a change to the cell format (in this cae, background colour) in cell 1A of sheet 1, the same change is automatically updated for the same cell in sheet 2. I have access to both Excel 2003 and 2007. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Linking cell format across worksheets
Please ignore post #2
-- Gary''s Student - gsnu200851 "PiL" wrote: I want to link cells across worksheets so that if I make a change to the cell format (in this cae, background colour) in cell 1A of sheet 1, the same change is automatically updated for the same cell in sheet 2. I have access to both Excel 2003 and 2007. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking 2 worksheets-Empty cell problem | Excel Discussion (Misc queries) | |||
hide results when cell value is 0 due to linking worksheets | Excel Discussion (Misc queries) | |||
Linking cell data between worksheets | Excel Discussion (Misc queries) | |||
LINKING CELL PATTERNS BETWEEN WORKSHEETS | Excel Worksheet Functions | |||
Linking a cell to worksheets and workbooks | New Users to Excel |