Table with many Column Names - How to efficiently generate a list ofhyperlinks to each Column Header

  • Thread starter Thread starter Mike C
  • Start date Start date
M

Mike C

Is there a "best way" to quickly identify all Column Headers (perhaps
to Create Names for them in a single step), so that I can paste them
in a separate tab (the list of names will be laid out vertically) and
then hyperlink to them within the table.

For instance, a my table has the following headers: Name, Age,
Weight.

I want to produce a list of those names in a separate tab (which will
serve as an index) that will allow me to hyperlink to those names.

It will look like this in the new tab:

Name
Age
Weight

If there is some code that may allow me to do this (or something
similar), please feel free to pass along.

Thanks for any suggestions!
 
To define those columns as named ranges, all you need to do is to
highlight the headers and the data below them and click on Insert |
Name | Create - unselect the option to have names in Left column so
that only Top Row is checked, then click OK.

To transfer the names vertically into another sheet, highlight the
names only, click <copy>, then select the other sheet and move the
cursor to the cell where you want the names to start and click on Edit
| Paste Special | Transpose (check) then OK and <Esc>.

Hope this helps - do you need help with the HYPERLINK formulae?

Pete
 
Back
Top