Name range within a name range

Name range within a name range

Post by dHJhdml » Sat, 11 Nov 2006 23:12:02


In Excel is it possible to create a name range that contains multiple name
ranges. As an example, I have created several name ranges with one cell
reference, such as Sales(A2), COS(A5), ADM(A7), SELLING(A8), MRKT(A9). I
would like to create a name range that I could include the all the name
ranges and call it GROSS_PROFIT. If later I add another range I would like
to be able to just add the range name to GROSS_PROFIT, such as R&D.

Also the reason I chose to use named ranges is my cell references can change
from month to month, I find it easier to create formulas using name
references then redefining the cell reference for the range. Then I could
use a formula like SUM(GROSS_PROFIT), rather than SUM(A2,A5,A7,A8,A9).

Thanks for your help.
 
 
 

Name range within a name range

Post by Dave Peter » Sat, 11 Nov 2006 23:30:23

Insert|Name|Define
Names in Workbook: Gross_Profit
refers to: =sales,cos,adm,selling,mrkt

When you want to add another range/name, just insert|name and add it.





--

Dave Peterson

 
 
 

Name range within a name range

Post by dHJhdml » Sat, 11 Nov 2006 23:37:02

Simple solution. Thank you!