Jake_Wrestler
Board Regular
- Joined
- Sep 3, 2003
- Messages
- 150
I often find myself often going into Insert -> Name -> Define and tediously changing my range names and parameters there. It is awfully time consuming.
Really I am just looking for a method to boost my effieciency.
In a perfect world I imagine a macro where I have two columns, one for the name of the range (i.e., ThompsonJune2001, ThompsonJune2002, MilfordJune2001, MilfordJune2002, etc. You can see how this could be time consuming if I have 4 years of monthly data from 5 or more stores [4 X 12 X 5 = 240 range names!!!]) and the other where I can specify the actual corresponding range (i.e., '6-2001'!$A$1:$AA$48, '6-2002'!$A$1:$AA$48, etc.).
From these two columns of input, the macro would create these named ranges on the fly. Is this macro possible??
If you think of an improvement if you can see what I am doing or any other suggestions for other ways that will help to boost my efficiency in creating name ranges like this.
thanks ray:
Really I am just looking for a method to boost my effieciency.
In a perfect world I imagine a macro where I have two columns, one for the name of the range (i.e., ThompsonJune2001, ThompsonJune2002, MilfordJune2001, MilfordJune2002, etc. You can see how this could be time consuming if I have 4 years of monthly data from 5 or more stores [4 X 12 X 5 = 240 range names!!!]) and the other where I can specify the actual corresponding range (i.e., '6-2001'!$A$1:$AA$48, '6-2002'!$A$1:$AA$48, etc.).
From these two columns of input, the macro would create these named ranges on the fly. Is this macro possible??
If you think of an improvement if you can see what I am doing or any other suggestions for other ways that will help to boost my efficiency in creating name ranges like this.
thanks ray: