Thank you all, guys. Dave is right: I was looking for "relief" in writing the
formulas in the first place, since a set of three formulas only differs by
one digit on the end. However, I have come to the conclusion that writing
each one from scratch is just as time-efficient as any alternative.

"Norman Jones" wrote:

Hi KG,

Since your names only differ by the last digit, having defined your first
name, you can use this as a template for the successive names: when defining
the second name, click on the (now) existing first name and edit the last
digit and redefine the corresponding range.

This should mean that for each successive name, you only need to type/edit a
single character


---
Regards,
Norman



"KG" wrote in message
...
As I prepare to link workbooks, I have to type descriptive range names,
e.g.:

CDA_GrossSales_Case1

Now, the workbook contains 3 different scenarios, therefore there will
also
be named ranges:

CDA_GrossSales_Case2 and
CDA_GrossSales_Case3

There will be several other sets of named ranges and, in each instance,
the
name will only differ by that one differentiating number on the end. Both
from the point of view of reducing typos and unnecessary typing, I have
been
looking (in vain!) for a way to copy the names from one range to the next,
so
that I all would have to do would be to change that one digit. Any
suggestions?