Defining a name that represent identical ranges in every sheet
This is the exact opposite of my previous post about "Defining identical
names that represent different ranges of cells".
In order to achieve this just type in an exclamation point before the range
definition, such as :
Insert/Name/Define
Name : Sales
Refers to : !A1:A3
The name Sales would then refer to cells A1:A3 local to every sheet.
Note that this is quite different from a "3D" reference.
|