+ Reply to Thread
Results 1 to 2 of 2

Extract column names by searching Row 1 header names?

  1. #1
    Registered User
    Join Date
    Boston, MA
    MS-Off Ver

    Extract column names by searching Row 1 header names?

    My name is Syfy, and I am a novice Excel user.
    I have been tracking captive animal growth and other natural history data on a spreadsheet.
    Sometimes I write a formula to analyze some simple relationships. My spreadsheet is evolving, right now I have 9 monthly columns, but over the last three years there have been less. My Row 1 column headers are consistent, for example, WT always means weight. On occasion, I insert a new column to look at some life history aspect mathematically. Each month I do data entry on the spreadsheet. I copy/paste the columns from the previous month, and enter new data. So far Excel is way smarter than I am and makes adjustments accordingly. But sometimes my formulas lose their original target columns. I assume this happens as a result of adding an exploratory column, or other rookie move on my part. At these moments, when I have to re-create the original formula, column name by column name, I feel dumb.

    Is there a way to search by my Row 1 header names, for example all columns with Row 1 header = "WT", and retain the original column names so that I can copy/paste the column names in the process of writing a new formula?
    I feel silly scrolling across my spreadsheet and writing down the column names on the back of junk mail envelopes so that I can type them into a new formula.
    Sometimes this might involve 20-30 columns or more. I have fiddled with a simple horizontal sort, but the column names are changed.

    Any help appreciated!

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16

    Re: Extract column names by searching Row 1 header names?

    Hi, welcome to the forum

    Before offering any suggestions, it would probably help if we could see a sample of what you are working with - and what you want.

    Another consideration, would be to enter all your data on 1 sheet, and then run your summaries/calcs/analysis etc from that
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you


+ 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. Accessing table row items by row and column header names
    By margie_68 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-15-2015, 10:19 AM
  2. Extract rows if names are meet names in named range
    By Serggio in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-19-2015, 07:26 AM
  3. Can I change Column Header Names?
    By zameer_india in forum Excel General
    Replies: 16
    Last Post: 10-22-2013, 04:58 PM
  4. Replies: 0
    Last Post: 08-29-2013, 10:07 PM
  5. Excel 07: Pivot Tables/Updating Column Header Names
    By fizzziks in forum Excel General
    Replies: 1
    Last Post: 03-19-2010, 09:41 AM


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