| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
linking cells
How can I have link two cells from different woksheets to change together?
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
linking cells
"Biovin" wrote:
How can I have link two cells from different woksheets to change together? In Sheet2, Put in A1: =IF(Sheet1!A1="","",Sheet1!A1) Copy across & fill down to cover the expected used range in Sheet1 Sheet2 will reflect the values within Sheet1 For formats, just do an entire sheet: Copy paste special check "Formats" OK (copy from Sheet1, paste in Sheet2) Formulas can return only values, not formats -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Linking cells | Excel Worksheet Functions | |||
| linking cells and assort decending | Excel Discussion (Misc queries) | |||
| Excel - linking cells | Excel Worksheet Functions | |||
| Linking Cells and applying a sort | Excel Worksheet Functions | |||
| linking cells colors | Excel Worksheet Functions | |||
Linear Mode
