Saturday, January 23, 2016
Macro of the day : Create dynamic Named Ranges using Macro
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
Give your valuable feedback.
Share to Twitter
Share to Facebook
Share to Pinterest
Post a Comment
Post Comments (Atom)