A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Using cell names across multiple worksheets



 
 
Thread Tools Display Modes
  #1  
Old October 8th, 2009, 02:50 PM posted to microsoft.public.excel.misc
M.Boone
external usenet poster
 
Posts: 2
Default 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  
Old October 8th, 2009, 03:10 PM posted to microsoft.public.excel.misc
Jim Thomlinson
external usenet poster
 
Posts: 2,641
Default 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  
Old October 8th, 2009, 03:24 PM posted to microsoft.public.excel.misc
M.Boone[_2_]
external usenet poster
 
Posts: 4
Default 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  
Old October 8th, 2009, 03:32 PM posted to microsoft.public.excel.misc
M.Boone[_2_]
external usenet poster
 
Posts: 4
Default 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  
Old October 8th, 2009, 03:42 PM posted to microsoft.public.excel.misc
Jim Thomlinson
external usenet poster
 
Posts: 2,641
Default 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?


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 09:41 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.