Macro of the day : Create dynamic Named Ranges using Macro

[vabs]

Hi All,

Working on dashboards & requires you to create defined name with huge data list, tired of creating names & updating it manually..

Here is simple solution using macro, what you need to do is..

1 - Enter data in main sheet to create defines names of your choice

2 - Macro will create unique names for each item in column B of sheet MainData;

3 - As soon as you type data in sheet MainData, names will get auto updated;

4 - To Delete all names & rebuilt name list click one of the above button;

For any query write back to us on Excel...@googlegroups.com

Give your valuable feedback.

Cheers!!

PS:

To download excel file you need to visit home page.

[Ashish Kumar]

Dear Vaibhav Sir,

Thanks for sharing this macro. It's Superb.

Regards

Ashish Kumar

[Ashish Bhalara]

Hi Vaibhavsir,

Thanks to sharing macro to define name range by VBA. It's very helpful to save time with accuracy in work.

Regards

Ashish Bhalara

[amartakale]

Wow.....Vabs Bro. This will be grt VBA Code to this group members & I salute always you from heart. You are God gift for our excel forum.

 

Many thanks for your help for our excel members.

 
Best regards,
Amar Takale

On Sunday, 24 January 2016 13:08:03 UTC+5:30, vabs wrote:

[Pratibha Sharma]

Dear Vaibhav Sir, 

It's very useful. Macro works well.

Thanks & Regards

Pratibha Sharma