Hello,
I need to define many names for chart series of the following type that allows for the chart to automatically adapt to expanding series:
name1=Excel!$E$36:INDEX(Excel!$E$36:$S$36,COUNT(Excel!$E$36:$S$36))
Is there any way to speed up this process, instead of defining them one by one in the name manager? I'm hoping I could perhaps write all my names in various rows along with their formulas in the column to the right and somehow import them into the name manager.
Alternatively, if this could be done through VBA, could someone suggest the code?
Thanks for any input!
I need to define many names for chart series of the following type that allows for the chart to automatically adapt to expanding series:
name1=Excel!$E$36:INDEX(Excel!$E$36:$S$36,COUNT(Excel!$E$36:$S$36))
Is there any way to speed up this process, instead of defining them one by one in the name manager? I'm hoping I could perhaps write all my names in various rows along with their formulas in the column to the right and somehow import them into the name manager.
Alternatively, if this could be done through VBA, could someone suggest the code?
Thanks for any input!