|
How do I duplicate value in multiple worksheets in same workbook?
When I change the value in Worksheet A, Cell C4 I want it to also change the value in Cell D8 in Worksheet B. How do I do this? -- jwnorris ------------------------------------------------------------------------ jwnorris's Profile: http://www.excelforum.com/member.php...o&userid=29324 View this thread: http://www.excelforum.com/showthread...hreadid=490421 |
How do I duplicate value in multiple worksheets in same workbook?
In D8 of worksheet B enter =worksheetA!C4
Gord Dibben Excel MVP On Sat, 3 Dec 2005 12:03:17 -0600, jwnorris wrote: When I change the value in Worksheet A, Cell C4 I want it to also change the value in Cell D8 in Worksheet B. How do I do this? |
How do I duplicate value in multiple worksheets in same workbo
I am a shortcut freak...so, in the cell where you want the information to end
up (Cell D8 in Worksheet B.) press the = keyuse CTRL and go to your source (Worksheet A, Cell C4), place your cursor on the cell. This should bring up your friendly blinking dashing line. The HIT ENTER!!!! This will place the information in the "end up" cell, and you will be on Worksheet B. "Nick Hodge" wrote: On worksheet B Cell D8 enter ='Worksheet A'!C4 -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England www.nickhodge.co.uk HIS "jwnorris" wrote in message ... When I change the value in Worksheet A, Cell C4 I want it to also change the value in Cell D8 in Worksheet B. How do I do this? -- jwnorris ------------------------------------------------------------------------ jwnorris's Profile: http://www.excelforum.com/member.php...o&userid=29324 View this thread: http://www.excelforum.com/showthread...hreadid=490421 |
| All times are GMT +1. The time now is 10:24 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com