| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
returning format from another spreadsheet
I have a master calender spreadsheet that references three department
calender spreadsheets. I would like to master to reflect the format of the cell it references, not just the value. Any ideas? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
returning format from another spreadsheet
The link formulas in the master return only the values, not the formats.
Copy the source cells and pasteSpecial format onto the master cells. -- Gary''s Student - gsnu200835 "kefee85" wrote: I have a master calender spreadsheet that references three department calender spreadsheets. I would like to master to reflect the format of the cell it references, not just the value. Any ideas? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
returning format from another spreadsheet
Unfortunately I can't cut and paste special since the cell is dynamic and the
master needs to reflect the change. Any other ideas? "Gary''s Student" wrote: The link formulas in the master return only the values, not the formats. Copy the source cells and pasteSpecial format onto the master cells. -- Gary''s Student - gsnu200835 "kefee85" wrote: I have a master calender spreadsheet that references three department calender spreadsheets. I would like to master to reflect the format of the cell it references, not just the value. Any ideas? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
returning format from another spreadsheet
There is no easy way to do what you have asked. Even using macros what you
want to do is a bit tricky as changing a format does not trigger an event so there is no easy way to react to the change. -- HTH... Jim Thomlinson "kefee85" wrote: Unfortunately I can't cut and paste special since the cell is dynamic and the master needs to reflect the change. Any other ideas? "Gary''s Student" wrote: The link formulas in the master return only the values, not the formats. Copy the source cells and pasteSpecial format onto the master cells. -- Gary''s Student - gsnu200835 "kefee85" wrote: I have a master calender spreadsheet that references three department calender spreadsheets. I would like to master to reflect the format of the cell it references, not just the value. Any ideas? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Returning Bottom 10 Percent in another spreadsheet | Excel Worksheet Functions | |||
| Returning Bottom 10 Percent in another spreadsheet | Excel Worksheet Functions | |||
| lookup function, returning the same format. | Excel Worksheet Functions | |||
| LOOKUP function not returning expected value - Using vector_lookup format | Excel Worksheet Functions | |||
| Formula for Returning values in another spreadsheet | Excel Worksheet Functions | |||
Hybrid Mode
