Excel Table Header Row

[ManUBlueJay]

I would like table 2 header rows to be linked to some of table 1' header row.
SO when I Change the header in the linked cell in table 1 it automatically changes in in table 2.

As soon as I link it and hit enter it inserts a 0 instead.
Any clues or work around would be appreciated.

 

[Peter_SSs]

@Yongle
You need to use the 'rich' code tags instead of the 'vba' tags if you want to apply your own format to vba code. That may be what is troubling the OP with the post 9 code.

 

[Yongle]

OOOPS
- I copied directly from previous post and pasted into vba tags and amended
- I did not intend to format anything, simply forgot that the formatting is pasted too

Let's try again - make the offset whatever you require it to be

Private Sub Worksheet_Change(ByVal Target As Range)
Sheets("XXX").ListObjects(1).HeaderRowRange.Value = Me.ListObjects(1).HeaderRowRange.Resize(, 8).Offset( ,1).Value
End Sub

 

[ManUBlueJay]

Score!!
Thank you for sticking with it. I learned a lot

 

[Peter_SSs]

OOOPS
- I copied directly from previous post and pasted into vba tags and amended
- I did not intend to format anything, simply forgot that the formatting is pasted too

Ahh, I see. All good now though.