Saturday, January 23, 2016

Macro of the day : Create dynamic Named Ranges using Macro

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 ExcelVbaLab@googlegroups.com



Give your valuable feedback.

Cheers!!


Click to Downloadfile