Maintaining Cell Values Across Sheets

[kknapper]

I have a column titled Server Name in 3 different sheets. When I change the server name in one sheet I want the server name to also change in all of the other sheets. If possible I'd like to be able to make the change in any of the 3 sheets and have it replicate, not just one. It's set up so that the row numbers will match in each sheet, i.e. server name X is in row 2 on all sheets.

Thanks in advance!

 

[lenze]

Hi and welcome to the Board!!!
Something like this in the ThisWorkSheet module

Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
If Target.Address <> "$B$2" Then Exit Sub
Dim ws As String
ws = ActiveSheet.CodeName
If ws <> "Sheet1" And ws <> "Sheet2" And ws <> "Sheet3" Then Exit Sub
Application.EnableEvents = False
Sheet1.Range("$B$2") = Target
Sheet2.Range("$B$2") = Target
Sheet3.Range("$B$2") = Target
Application.EnableEvents = True
End Sub

Right Click the excel icon to the left of "File on" the menu bar and choose "View Code"
lenze

 

[kknapper]

Thanks Lenze. I am using Office 2007. I went to the Developer tab (I couldn't find 'File On' on the menu bar) and clicked on View Code. I pasted the code in there and saved it, but nothing happened. Obviously I'm doing something wrong?

thanks for your help!

 

[lenze]

I don't know about Excel 2007's interface. Try opening the VBE with ALT+F11. You should should see the ThisWorkBook module in the Project Explorer(Left side of screen) You may have to call it up with CTRL+R

lenze