How to reference a column name of a table

HI

How can I only reference the column name of the right table to the column name of left table ( NOT WHOLE TABLE ONLY COLUMN NAME) .

For example when I change the name of first column in the left table from ""column 1"" to "AA" the name of the column 1 in right table will be changed from ""column 1"" to ""AA"" AUTOMATICALLY.

THANK YOU

Hi and welcome
are those Excel Tables ( with Data - Insert - Table) or juts ranges that one usually calls "tables"?

HI. THANK YOU

with Data - Insert - Table

Originally Posted by Pepe Le Mokko

Hi and welcome
are those Excel Tables ( with Data - Insert - Table) or juts ranges that one usually calls "tables"?

HI. THANK YOU

with Data - Insert - Table

Originally Posted by oeldere

Change the name in the column of the original data and after that make a table of it.


If you change the name afterwards you need to built the pivot table on that item again, since it is not available in the pivot table.

Thank you . But I need to change the name repeatedly . I can not make a new table every time

Originally Posted by Andy Pope

You can not use formula to return the column name.
You could use VBA in the Change event of the worksheet to update the column name
Right click sheet tab and click View Code. Paste the following.

Please Login or Register  to view this content.

Change the name of the tables referenced to match your table names.

Thank you ..

Administrative Note:

Please don't quote entire posts unnecessarily. They clutter threads and make them hard to read.
Use the "Quick reply" instead
Thanks