• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 421
  • Last Modified:

Referencing column headers as a list in another column

Is there a formula I can use to reference many column headers in order to create them as a list on another sheet, making sure the list reflects any changes the headers might undergo?

I do not want to copy/paste special/transpose and just using the = sign to go and grab the cell reference itself is a bit tedious.  

Attached is a mock up that I hope will help illustrate the problem.  Please let me know if you have any questions!

Many thanks.
ColumnHeadings.xlsx
0
xllvr
Asked:
xllvr
1 Solution
 
barry houdiniCommented:
Assuming you know that headers will start at E5 then try this formula in B9 copied down as far as might be required

=INDEX($E$5:$IV$5,ROWS(B$9:B9))&""

regards, barry
0
 
xllvrAuthor Commented:
Works great, Barry.  Thanks very much!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: MCSA MCSE Windows Server 2012

This course teaches how to install and configure Windows Server 2012 R2.  It is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).

Tackle projects and never again get stuck behind a technical roadblock.
Join Now