Automatically create Named range

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 :)
 

Some videos you may like

Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.

L. Howard

Well-known Member
Joined
Oct 16, 2012
Messages
4,514
Its pretty much a mystery what the sheet and the data looks like.

What is a "group" ?
What are the items?
What does together mean, same cell, same column, same row?

What determines the range to be named, and by "able" do you a macro?

Code:
I would like to be able to create name ranges based on the value on this cell.

Can you post a small amount of you sheet along with what you want to happen and where it should happen?

Perhaps manually construct a "finished product" to show a before and an after, so to speak.

Howard
 

alainfranco

New Member
Joined
Mar 7, 2012
Messages
38
Capture.PNG
 

L. Howard

Well-known Member
Joined
Oct 16, 2012
Messages
4,514
Well, I saw and I pondered and I have to say I do not know how to tackle this.

Hopefully, with the example screen shot, someone will else will pounce on it.

Sorry.

Howard
 

Watch MrExcel Video

Forum statistics

Threads
1,123,125
Messages
5,599,843
Members
414,342
Latest member
K Darrell Smith

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top