[kpink]

I have a fairly detailed data set that I would like to base named ranges off of. The thing is, the data set changes quite often. I would like to list a range of cells under a defined name range based on data in a corresponding column. For example: there is a list of account names in column b, tied to peoples' names in column a. I would like the named range for person "Steve" to include all account names in column b that have steve's name listed in column a. As I continue to add more account names as time goes on, I would like the name range to adapt to the change automatically. I've tried using the vlookup formula in the formula bar for the name range, and have had no luck. I am willing to try VBA if necessary.

Thank you for your help.

[pascal baro]

Hi,

Indirect formula seems to be most helpful for this. If you could provide a direct example through a file or how the data looks like, it would make things easier to work out. For instance, are names alphabetically sorted so that you can have a continuous named range?

Vba has a referToRange method that also deals with named range...

Provide more information and I'll see

Pascal Baro

[Don Guillett[_2_]]

On Monday, July 23, 2012 12:03:32 PM UTC-5, kpink wrote:
I have a fairly detailed data set that I would like to base named ranges off of. The thing is, the data set changes quite often. I would like to list a range of cells under a defined name range based on data in a corresponding column. For example: there is a list of account names in column b, tied to peoples' names in column a. I would like the named range for person "Steve" to include all account names in column b that have steve's name listed in column a. As I continue to add more account names as time goes on, I would like the name range to adapt to the change automatically. I've tried using the vlookup formula in the formula bar for the name range, and have had no luck. I am willing to try VBA if necessary.

Thank you for your help.

If desired send file direct to dguillett1 @gmail.com with examples