Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Same data box on two pages?
Is it possible to have the same data box on two sheets, such that you can change either box and they both change? -- mattflow ------------------------------------------------------------------------ mattflow's Profile: http://www.excelforum.com/member.php...o&userid=25129 View this thread: http://www.excelforum.com/showthread...hreadid=386291 |
#2
|
|||
|
|||
Assuming you are meaing a cell when you say data box then you can achieve
this using the change events on the sheets. So if you want to have cell A1 on Sheet2 equal whatever is in cell A1 on Sheet1 and vice versa then right click on the Sheet1 sheet tab and select View code. Paste this macro onto the code sheet: Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = "$A$1" Then Application.EnableEvents = False Sheets("Sheet2").Range("A1").Value = Target.Value Application.EnableEvents = True End If End Sub The right click on the Sheet2 sheet tab, select view code and past this macro: Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = "$A$1" Then Application.EnableEvents = False Sheets("Sheet1").Range("A1").Value = Target.Value Application.EnableEvents = True End If End Sub Now if you change cell A1 on either sheet, A1 on the other sheet will also change. Hope this helps Rowan "mattflow" wrote: Is it possible to have the same data box on two sheets, such that you can change either box and they both change? -- mattflow ------------------------------------------------------------------------ mattflow's Profile: http://www.excelforum.com/member.php...o&userid=25129 View this thread: http://www.excelforum.com/showthread...hreadid=386291 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot table show pages but omit those without data | Excel Discussion (Misc queries) | |||
Macro to search for and display data in another worksheet | Excel Worksheet Functions | |||
Import Data Keeps asking for Password | Excel Discussion (Misc queries) | |||
Pivot table - printing specific data | Excel Discussion (Misc queries) | |||
Copying conditional formatting...HELP PLEASE!!!! | Excel Worksheet Functions |