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 of 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?
Heres is simplified version of my spreadsheet.
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 of 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?
Heres is simplified version of my spreadsheet.
Many thanks