#1   Report Post  
Old March 4th 05, 05:01 PM
pmw5
 
Posts: n/a
Default Naming ranges?

Hi,

I have no problem naming ranges of cells in XL. However, I have the
following scenario that I can't find a solution to:

Imagine you have 5 identical worksheets. You want to highlight a data range
which is also indentical in each worksheet.

Can you create 1 range name that applies to a range of cells on each
worksheet, rather than having to create 5 different named ranges (1 for each
worksheet)?

It is odd because if you have 1 worksheet, name a range, and then make 4
copies, they will all have the same range under the same name - so it must be
possible to do it the other way around?

You might say: if they are identical, then go back to just one, create the
named range, and then make 4 copies to get the 5 sheets. However this is not
feasible for me for reasons I can't really go into (work related).

I hope the above makes sense to people.

Many thanks in advance for any clues.

Pete

  #2   Report Post  
Old March 4th 05, 06:08 PM
Jason Morin
 
Posts: n/a
Default

I only have XL2003 on my PC, so I'm not sure if this
works in earlier versions:

1. Press Ctrl+F3 and type in a defined name.
2. Click in the "Refers To:" box.
3. Delete what's in there.
4. While holding down the <Shift key, select the range
on the first sheet, click the second sheet tab, select
the same range, and continue on to the last sheet.
5. Press OK.

HTH
Jason
Atlanta, GA

-----Original Message-----
Hi,

I have no problem naming ranges of cells in XL. However,

I have the
following scenario that I can't find a solution to:

Imagine you have 5 identical worksheets. You want to

highlight a data range
which is also indentical in each worksheet.

Can you create 1 range name that applies to a range of

cells on each
worksheet, rather than having to create 5 different

named ranges (1 for each
worksheet)?

It is odd because if you have 1 worksheet, name a range,

and then make 4
copies, they will all have the same range under the same

name - so it must be
possible to do it the other way around?

You might say: if they are identical, then go back to

just one, create the
named range, and then make 4 copies to get the 5 sheets.

However this is not
feasible for me for reasons I can't really go into (work

related).

I hope the above makes sense to people.

Many thanks in advance for any clues.

Pete
.

  #3   Report Post  
Old March 4th 05, 06:57 PM
Peo Sjoblom
 
Posts: n/a
Default

Works the same in 97 onwards

--

Regards,

Peo Sjoblom


"Jason Morin" wrote in message
...
I only have XL2003 on my PC, so I'm not sure if this
works in earlier versions:

1. Press Ctrl+F3 and type in a defined name.
2. Click in the "Refers To:" box.
3. Delete what's in there.
4. While holding down the <Shift key, select the range
on the first sheet, click the second sheet tab, select
the same range, and continue on to the last sheet.
5. Press OK.

HTH
Jason
Atlanta, GA

-----Original Message-----
Hi,

I have no problem naming ranges of cells in XL. However,

I have the
following scenario that I can't find a solution to:

Imagine you have 5 identical worksheets. You want to

highlight a data range
which is also indentical in each worksheet.

Can you create 1 range name that applies to a range of

cells on each
worksheet, rather than having to create 5 different

named ranges (1 for each
worksheet)?

It is odd because if you have 1 worksheet, name a range,

and then make 4
copies, they will all have the same range under the same

name - so it must be
possible to do it the other way around?

You might say: if they are identical, then go back to

just one, create the
named range, and then make 4 copies to get the 5 sheets.

However this is not
feasible for me for reasons I can't really go into (work

related).

I hope the above makes sense to people.

Many thanks in advance for any clues.

Pete
.





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Naming Ranges Simon Shaw Excel Discussion (Misc queries) 1 February 15th 05 01:17 AM
Sorting Multiple Ranges simoneaux Excel Worksheet Functions 1 February 8th 05 03:11 PM
Naming Ranges Donna In Denver Excel Discussion (Misc queries) 1 January 28th 05 07:48 AM
compare unique identifiers in multiple ranges bawilli_91125 Charts and Charting in Excel 1 November 30th 04 06:34 PM
Named dynamic ranges, copied worksheets and graph source data WP Charts and Charting in Excel 1 November 28th 04 05:19 PM


All times are GMT +1. The time now is 08:57 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017