Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Circular Referance
Hey, I don't know if this is possible or even where the post should be, but here is what I want to do. Is there a way to have 2 cells that reference each other, so that when you type in one, the value shows up in both cells. The catch is that I want to be able to enter data in either cell, so you can't have a standard reference link. Any ideas on how to acomplish this? John Vickers -- John Vickers ------------------------------------------------------------------------ John Vickers's Profile: http://www.excelforum.com/member.php...o&userid=31551 View this thread: http://www.excelforum.com/showthread...hreadid=512459 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Circular Referance
Hi John,
this can only be done by a VBA module - afaik. Assuming those two cells are A1 and G1 - try to use this code for the Worksheet_Change event: Private Sub Worksheet_Change(ByVal Target As Range) If Target = ActiveSheet.Range("A1") Then ActiveSheet.Range("G1") = Target.Value ElseIf Target = ActiveSheet.Range("G1") Then ActiveSheet.Range("A1") = Target.Value End If End Sub Did this help you? Best wishes, Eric "John Vickers" wrote: Hey, I don't know if this is possible or even where the post should be, but here is what I want to do. Is there a way to have 2 cells that reference each other, so that when you type in one, the value shows up in both cells. The catch is that I want to be able to enter data in either cell, so you can't have a standard reference link. Any ideas on how to acomplish this? John Vickers -- John Vickers ------------------------------------------------------------------------ John Vickers's Profile: http://www.excelforum.com/member.php...o&userid=31551 View this thread: http://www.excelforum.com/showthread...hreadid=512459 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Circular Referance
OK, I got that to work fine, and it does what I want. Here is the next step, I will be populating a list from a macro in the module, and I will need to create these linked cells dynamicly. Do you know of a way to write a macro from a macro? In other words, add sets of linked cells like you show here depending on the list it is populated from. So say I have a list of 4 rows of data, when I populate the sheet, I would need 4 sets of linked cells, but if the list has 5 rows of data, then there would need to be 5 sets of linked cells. The formatting will be to a particular format, so I can do the programming of that, but how can I add to the linked cells from a macro? John Vickers -- John Vickers ------------------------------------------------------------------------ John Vickers's Profile: http://www.excelforum.com/member.php...o&userid=31551 View this thread: http://www.excelforum.com/showthread...hreadid=512459 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Create dictionary of terms, create first time user site | New Users to Excel | |||
Circular Reference... Help! | Excel Worksheet Functions | |||
Iterate Circular Reference | Excel Discussion (Misc queries) | |||
Circular warning not showing up | Excel Discussion (Misc queries) | |||
Highest Value / Circular Reference Help | Excel Worksheet Functions |