| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
Copying Cells from one worksheet to another automaticly
I have a document with 5 worksheets. When I update say worksheet one in a
certain cell, I want it to update worksheet 5 in certain cell. Can this be done? |
|
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
|
Copying Cells from one worksheet to another automaticly
In any cell on Sheet5 enter =IF(Sheet1!A1="","",Sheet1!A1)
When you change the data in Sheet1!A1, the formula on Sheet5 will return that value. Gord Dibben MS Excel MVP On Tue, 22 May 2007 07:13:00 -0700, loc wrote: I have a document with 5 worksheets. When I update say worksheet one in a certain cell, I want it to update worksheet 5 in certain cell. Can this be done? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copying Worksheet Cells Getting 0's | Excel Discussion (Misc queries) | |||
| copying cells to another worksheet | Excel Worksheet Functions | |||
| Copying a worksheet witrh protected cells to a new worksheet | Excel Worksheet Functions | |||
| automaticly copy data from one worksheet to another | Excel Discussion (Misc queries) | |||
| copying cells to another worksheet | Excel Worksheet Functions | |||
Linear Mode
