Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to link format of cells
I need to update the format/appearance (text and fill color, border etc) in
other worksheets, as and when I manually change them on the first sheet. More clearly, I have to generate four different types of consolidated reports from the daily reports. I have a master worksheet for updating/entering the daily reports ( i change the cell content and appearance). As a when I updated this worksheet for daily reports, the relevant cells in the other sheets should display the same content and more importantly should apprear same as in the daily report worksheet. Can anybody help????? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to link format of cells
Hi,
Formulas do not pass formatting, they return values. You will need to program Excel to handle this type of situation. Cheers, Shane Devenshire "ramesh" wrote in message ... I need to update the format/appearance (text and fill color, border etc) in other worksheets, as and when I manually change them on the first sheet. More clearly, I have to generate four different types of consolidated reports from the daily reports. I have a master worksheet for updating/entering the daily reports ( i change the cell content and appearance). As a when I updated this worksheet for daily reports, the relevant cells in the other sheets should display the same content and more importantly should apprear same as in the daily report worksheet. Can anybody help????? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
need to paste link from 4 vertical cells to 4 horizontal cells? | Excel Discussion (Misc queries) | |||
PASTE LINK FROM HORIZONTAL CELLS TO VERTICAL CELLS | Excel Discussion (Misc queries) | |||
want format cells alignment not format cells font style | Excel Discussion (Misc queries) | |||
I want in one worksheet to relatively link to/reference cells in another without changing the format of the current worksheet. | Excel Discussion (Misc queries) | |||
How to link cells and keep number format altogether | Excel Discussion (Misc queries) |