In excel, how do i reference the name in a cell from another worksheet into a different sheet's header?

for example, if i type in a company's name on the first sheet, how do I make that automatically change the name in the headers. if i type Google into the first sheet's cell, I want the headers for all the other sheets to change to Google as well. if anybody has the VB code, i would appreciate your help.
In excel, how do i reference the name in a cell from another worksheet into a different sheet's header?
It sounds like you could do this without using any VB at all, just put in a basic link to the cell in your other sheets.



If you enter %26quot;Google%26quot; in A1 of Sheet1, and want whatever is in cell A1 to have that displayed on another sheet, enter this in a cell on your other sheet:



='Sheet1'!A1
In excel, how do i reference the name in a cell from another worksheet into a different sheet's header?
To mirror cell Say A1 to other A1 on other sheets of same workbook, here's the code to put on the specific sheet module, go to the buttom tab of the sheet and right click to choose view code then paste the following in the right blank area

Private Sub Worksheet_Change(ByVal Target As Range)

聽聽聽Application.ScreenUpdating = False

聽聽聽mirrorCell = %26quot;A1%26quot; 'can change to a column %26quot;A:A%26quot;, a few rows %26quot;$1:$3%26quot;, a block of cells %26quot;A1:C3%26quot;, whole page %26quot;$1:$65536%26quot;

聽聽聽If Not Intersect(Target, Range(mirrorCell)) Is Nothing Then

聽聽聽聽聽聽For Count = 1 To Worksheets.Count

聽聽聽聽聽聽聽聽聽If Worksheets( Count).Name %26lt;%26gt; ActiveSheet.Name Then Worksheets( Count).Range( Target.Address).Value = Target.Value

聽聽聽聽聽聽Next

聽聽聽End If

聽聽聽Application.ScreenUpdating = False

End Sub

Hope this helps.

face nail siding

cope with divorce