ExcelBanter - Create range names with names in column heading

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Create range names with names in column heading (https://www.excelbanter.com/excel-programming/414615-create-range-names-names-column-heading.html)

NigelVII

Create range names with names in column heading

Hi,

Need some help.

I have a sheet that has column headings along row 1. Would like to create
range names with each column heading as the name. The number of rows will
increase.

Any suggestions?

Office_Novice

Create range names with names in column heading

Look for dynarange

http://www.cpearson.com/excel/Download.htm

"NigelVII" wrote:

Hi,

Need some help.

I have a sheet that has column headings along row 1. Would like to create
range names with each column heading as the name. The number of rows will
increase.

Any suggestions?

NigelVII

Create range names with names in column heading

"Office_Novice" wrote:
Thanks for the assistance much appreciated

Look for dynarange

http://www.cpearson.com/excel/Download.htm

"NigelVII" wrote:

Hi,

Need some help.

I have a sheet that has column headings along row 1. Would like to create
range names with each column heading as the name. The number of rows will
increase.

Any suggestions?

All times are GMT +1. The time now is 08:44 AM.