Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy format of cell from other worksheet
When you tell a cell to display the contents of a cell from another worksheet
(eg. if in a cell from Sheet2 I put the formula ='Sheet1'!A1), how do you also get it to use the formatting of that cell? Thanks in advance for looking! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy format of cell from other worksheet
Formulas don't return this kind of formatting. They return values.
You could copy|paste or have a macro do it. sirjibby wrote: When you tell a cell to display the contents of a cell from another worksheet (eg. if in a cell from Sheet2 I put the formula ='Sheet1'!A1), how do you also get it to use the formatting of that cell? Thanks in advance for looking! -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy format of cell from other worksheet
Ok thanks for letting me know. Could you possibly explain quickly how I would
get a macro to do that? "Dave Peterson" wrote: Formulas don't return this kind of formatting. They return values. You could copy|paste or have a macro do it. sirjibby wrote: When you tell a cell to display the contents of a cell from another worksheet (eg. if in a cell from Sheet2 I put the formula ='Sheet1'!A1), how do you also get it to use the formatting of that cell? Thanks in advance for looking! -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy format of cell from other worksheet
As quickly as you can record yourself doing the copy then Paste
SpecialPaste links and Paste SpecialFormats. Gord Dibben MS Excel MVP On Fri, 29 Aug 2008 15:20:00 -0700, sirjibby wrote: Ok thanks for letting me know. Could you possibly explain quickly how I would get a macro to do that? "Dave Peterson" wrote: Formulas don't return this kind of formatting. They return values. You could copy|paste or have a macro do it. sirjibby wrote: When you tell a cell to display the contents of a cell from another worksheet (eg. if in a cell from Sheet2 I put the formula ='Sheet1'!A1), how do you also get it to use the formatting of that cell? Thanks in advance for looking! -- Dave Peterson |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy format of cell from other worksheet
On top of what Gord suggested, you could have an event macro that runs that does
the copy|Paste. But you'd have to share how the "sending" cell changed--is it because the user typed something, or is it because the formula got reevaluated? And if you're sharing this, share the details of what cells are sending cells and what cells are the corresponding receiving cells. sirjibby wrote: Ok thanks for letting me know. Could you possibly explain quickly how I would get a macro to do that? "Dave Peterson" wrote: Formulas don't return this kind of formatting. They return values. You could copy|paste or have a macro do it. sirjibby wrote: When you tell a cell to display the contents of a cell from another worksheet (eg. if in a cell from Sheet2 I put the formula ='Sheet1'!A1), how do you also get it to use the formatting of that cell? Thanks in advance for looking! -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lock Cell Format - Allow copy and paste of data without format change | Excel Worksheet Functions | |||
How to copy the format of one worksheet to others in same book? | Excel Discussion (Misc queries) | |||
How do I copy data in single cell format to a merged cell format | Excel Discussion (Misc queries) | |||
how do i copy the format of a cell from one worksheet to another | Excel Discussion (Misc queries) | |||
How do I copy a cell (content AND format) from one worksheet to a. | Excel Worksheet Functions |