+ Reply to Thread
Results 1 to 4 of 4

Update Formulas Automatically After Inserting a Table to Show Table Column Names

  1. #1
    Forum Contributor
    Join Date
    07-22-2013
    Location
    london
    MS-Off Ver
    Excel 2013
    Posts
    133

    Update Formulas Automatically After Inserting a Table to Show Table Column Names

    Hello All

    Say you were given a long (private) worksheet with a lot of formulas that use references as columns and rows like this:

    F25:
    =A25+C25/E24

    And each of these cells/references are calling other references (imagine 200 columns and 2000 rows like that).
    It quickly becomes very difficult to read/understand the formulas.
    Maybe the creator forgot to build the formulas within a table so that each column have its own name/description and make them easier to read.

    So you select all the data and insert a table. But the formulas are still showing the column letter instead of the table column name.

    The question is: how can we automatically replace the letter for the table column name in all the formulas?
    (I hope is clear enough)

  2. #2
    Forum Expert avk's Avatar
    Join Date
    07-12-2007
    Location
    India
    MS-Off Ver
    Microsoft Office 2013
    Posts
    3,223

    Re: Update Formulas Automatically After Inserting a Table to Show Table Column Names

    If you attach sample file with desire result its more clarity.


    atul


    If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.

    Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".

  3. #3
    Forum Contributor
    Join Date
    07-22-2013
    Location
    london
    MS-Off Ver
    Excel 2013
    Posts
    133

    Re: Update Formulas Automatically After Inserting a Table to Show Table Column Names

    I know, but in this case I cannot share the file as is private and a sample would take time to build.
    Was hoping for a simple solution.

    Is it really not clear enough?

  4. #4
    Forum Expert avk's Avatar
    Join Date
    07-12-2007
    Location
    India
    MS-Off Ver
    Microsoft Office 2013
    Posts
    3,223

    Re: Update Formulas Automatically After Inserting a Table to Show Table Column Names

    In that case case attach dummy file with required desired result.

+ 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: 6
    Last Post: 12-21-2016, 03:22 AM
  2. Automatically Update Table from Pivot Table
    By toci in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-06-2015, 03:58 PM
  3. Update table Automatically by inserting into another
    By jmcconville18 in forum Excel General
    Replies: 1
    Last Post: 06-02-2014, 09:50 PM
  4. Replies: 0
    Last Post: 03-17-2014, 08:41 AM
  5. Show query column names behind pivot table field names
    By gbritton in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 11-18-2013, 03:17 PM
  6. Please show me how to automatically add a blank column before each table
    By vijnanamatrata in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-02-2013, 10:38 AM
  7. [SOLVED] Search a list of names and automatically return any names not already included in table
    By bishbash89 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-21-2013, 09:06 AM

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