Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Print all charts in a workbook (multiple worksheets) | Charts and Charting in Excel | |||
Linking between multiple worksheets, workbooks and columns | Excel Discussion (Misc queries) | |||
how do i look through worksheets in a workbook to find duplicate | Excel Worksheet Functions | |||
Multiple workbook user's with Master workbook - all password protected | Excel Discussion (Misc queries) | |||
How to search multiple worksheets in a workbook for information? | Excel Discussion (Misc queries) |