+ Reply to Thread
Results 1 to 9 of 9

How to reference a column name of a table

  1. #1
    Registered User
    Join Date
    04-28-2020
    Location
    Toronto
    MS-Off Ver
    2016
    Posts
    27

    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
    Attached Images Attached Images

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux - O365
    Posts
    12,687

    Re: How to reference a column name of a table

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

  3. #3
    Registered User
    Join Date
    04-28-2020
    Location
    Toronto
    MS-Off Ver
    2016
    Posts
    27

    Re: How to reference a column name of a table

    HI. THANK YOU

    with Data - Insert - Table

  4. #4
    Registered User
    Join Date
    04-28-2020
    Location
    Toronto
    MS-Off Ver
    2016
    Posts
    27

    Re: How to reference a column name of a table

    Quote Originally Posted by Pepe Le Mokko View Post
    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

  5. #5
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,423

    Re: How to reference a column name of a table

    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.
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  6. #6
    Registered User
    Join Date
    04-28-2020
    Location
    Toronto
    MS-Off Ver
    2016
    Posts
    27

    Re: How to reference a column name of a table

    Quote Originally Posted by oeldere View Post
    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

  7. #7
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,114

    Re: How to reference a column name of a table

    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.
    Cheers
    Andy
    www.andypope.info

  8. #8
    Registered User
    Join Date
    04-28-2020
    Location
    Toronto
    MS-Off Ver
    2016
    Posts
    27

    Re: How to reference a column name of a table

    Quote Originally Posted by Andy Pope View Post
    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 ..

  9. #9
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux - O365
    Posts
    12,687

    Re: How to reference a column name of a table

    Administrative Note:

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

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 1
    Last Post: 03-25-2018, 04:16 PM
  2. Replies: 0
    Last Post: 08-18-2017, 03:03 PM
  3. Replies: 11
    Last Post: 07-18-2013, 05:14 PM
  4. Copy chart, reverence to source data
    By Meathead in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 07-05-2013, 12:13 AM
  5. Replies: 3
    Last Post: 06-04-2013, 01:00 PM
  6. [SOLVED] Automatically create a column in one table from the totals column in another table
    By TravisRauch in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-07-2012, 02:56 PM
  7. Best way to have sheets reverence one sheet
    By MattG in forum Excel General
    Replies: 5
    Last Post: 11-22-2010, 06:39 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1