want to use ranges from seperate

[noodlehead777]

i have name ranges on one sheet, the new sheet has the same ranges but are shifted and dont match up with the ranges, i want to move the ranges on the 2nd sheet so i can use the name ranges on the first and have them match up
jason

[RagDyeR]

Try,
<Insert> <Name> <Define>
And click on the range name in the big window,
Then click in the "Refers To" box,
Hit <F2>
And revise the address references to match what you want.
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

"noodlehead777" <[email protected]>
wrote in message
news:[email protected]...

i have name ranges on one sheet, the new sheet has the same ranges but
are shifted and dont match up with the ranges, i want to move the
ranges on the 2nd sheet so i can use the name ranges on the first and
have them match up
jason


--
noodlehead777
------------------------------------------------------------------------
noodlehead777's Profile:
http://www.excelforum.com/member.php...o&userid=29283
View this thread: http://www.excelforum.com/showthread...hreadid=490450