alainfranco
New Member
- Joined
- Mar 7, 2012
- Messages
- 38
Hello,
I am trying to get something working that would required Name Ranges to be created automatically based on the content of specific cells.
Specifically, I have a column called GROUP that contains a numerical value (1 to 20) which allows me to "group" items together. I would like to be able to create name ranges based on the value on this cell.
So that, all items with value "1" (for instance) are grouped together in a name range called Group1, and then the same for items with value "2", which would be grouped together in a named range called Group2, and so on so forth.
Is this feasible in excel? If so, could you please point me in the right direction?
Many thanks
I am trying to get something working that would required Name Ranges to be created automatically based on the content of specific cells.
Specifically, I have a column called GROUP that contains a numerical value (1 to 20) which allows me to "group" items together. I would like to be able to create name ranges based on the value on this cell.
So that, all items with value "1" (for instance) are grouped together in a name range called Group1, and then the same for items with value "2", which would be grouped together in a named range called Group2, and so on so forth.
Is this feasible in excel? If so, could you please point me in the right direction?
Many thanks