| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
copy cells from one worksheet to another
How do I make the "value" or content of a cell on 'worksheet 1' mirror or
copy the font color (and strike through) of a cell on a seperate worksheet? - 'worksheet 2'? thanks. |
|
#2
|
|||
|
|||
|
Copy and paste special|values
followed by Paste special|formats If you were using a formula, then that formula can only return the value--it can't change the format. Depending on how that other cell changed, you could have an event macro do the work for you. Garrett wrote: How do I make the "value" or content of a cell on 'worksheet 1' mirror or copy the font color (and strike through) of a cell on a seperate worksheet? - 'worksheet 2'? thanks. -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Linking cells in a worksheet to other worksheets in a workbook | Excel Discussion (Misc queries) | |||
| How to copy subtotalled cells to a new worksheet (in a macro), wi. | Excel Discussion (Misc queries) | |||
| Copy down - special to fill only the blank cells | Excel Discussion (Misc queries) | |||
| how do I make a copy of a worksheet and retain formulas but not data | Setting up and Configuration of Excel | |||
| copy group of cells to another group of cells using "IF" in third | Excel Worksheet Functions | |||
Linear Mode
