Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using cell names across multiple worksheets
I have multiple worksheets that have the same layout and I want to name
certain cells to make calculations easier. When I try to do this, I get a message that the name is not unique. Is there any way to get around this? I want to create a template for future worksheets. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using cell names across multiple worksheets
Named ranges fall into two categories. Global and Local. Local names are
sheet specific. An example would be Print_Area. When you define a print area XL creates a local named range on that sheet called Print_Area. Each sheet in your workbook can have a local print area named range. To create a locally defined named range use 'Sheet1'!MyName instead of just MyName MyName can be duplicated on each sheet in the workbook. There are scope issues when you are refering to these named ranges. -- HTH... Jim Thomlinson "M.Boone" wrote: I have multiple worksheets that have the same layout and I want to name certain cells to make calculations easier. When I try to do this, I get a message that the name is not unique. Is there any way to get around this? I want to create a template for future worksheets. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using cell names across multiple worksheets
Thank you : ) I rather feel like an idiot since I also figured out I was
using the same name as a column (TT). |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using cell names across multiple worksheets
Ugh, me again.
I tried to create another named range and received the already exists error. I entered the name as Template!BuyMU and 'Template'!BuyMU. I found where I had used simply BuyMU (although it was listed as only having scope within that worksheet) and attempted to change it to 'Work sheet'!BuyMU. Got the same error. These are the only two places I've tried to use this name. Suggestions? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using cell names across multiple worksheets
Get a copy of name manager. It is the best tool out there for manageing named
ranges. It will allow you to swap names from global to local... http://www.oaltd.co.uk/MVP/ -- HTH... Jim Thomlinson "M.Boone" wrote: Ugh, me again. I tried to create another named range and received the already exists error. I entered the name as Template!BuyMU and 'Template'!BuyMU. I found where I had used simply BuyMU (although it was listed as only having scope within that worksheet) and attempted to change it to 'Work sheet'!BuyMU. Got the same error. These are the only two places I've tried to use this name. Suggestions? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do i use the same cell name accross multiple tab names in a wo | Excel Discussion (Misc queries) | |||
Formula - Capture Multiple names into One cell | New Users to Excel | |||
How do I sort multiple names within one cell? | Excel Worksheet Functions | |||
Semi-automating the generation of multiple cell range names | Excel Discussion (Misc queries) | |||
apply cell names to formulas in multiple worksheets | Excel Worksheet Functions |