Dynamic Name Ranges using Table column Header

[thewiseguy]

Hi all. Is there a way to do this? I thought there was a way to create a dynamic range using the header name of a specific table so that as I add items to the table, the name range expands as well. I couldn't seem to find anything online.

Any help is greatly appreciated!

 

[Fluff]

Simply select the entire table column (minus the header) &give it a name.

 

[thewiseguy]

Simply select the entire table column (minus the header) &give it a name.

will this work if i renamed the table?

 

[Fluff]

Best way to find out, is try it

 

[thewiseguy]

Best way to find out, is try it

LOL i'm not sure what happened. my validation list wasn't picking it up at first. thanks again

 

[Fluff]

You're welcome & thanks for the feedback.