Power Query Course in Spanish
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 6 of 6

Thread: Copy a named range from one worksheet to another

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I'm no expert w/ Excel for sure but I'd like to copy a named range from one worksheet to another but can't figure out how to do it.

    Thanks for any help you can give me, Dave

  2. #2
    New Member
    Join Date
    Jan 2002
    Location
    Canada
    Posts
    42
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Select the entire range, click on Copy icon.
    Go to the new worksheet, click in the cell where you want the range to begin, click the Paste icon.

  3. #3
    Board Regular
    Join Date
    Feb 2002
    Posts
    202
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    dave
    phylis' suggestion will certainly copy the cells in the range, but i got the impression you wanted to take the range name itself as well as the cells.
    if it's from one worksheet to another in the same workbook you won't be able to do it because you can't have duplicate range names in a workbook, even if they are in different worksheets.
    if it's pasting to another workbook you'll again do as phylis suggested and then define the range name over again. as far as i know there's no way to take the range name to another workbook unless you copy the whole sheet across.


    [ This Message was edited by: anno on 2002-04-16 23:05 ]

    [ This Message was edited by: anno on 2002-04-16 23:09 ]

  4. #4
    New Member
    Join Date
    Apr 2002
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Anno, You're correct, I wanted to copy the named range to another worksheet in the same workbook. But what is it called when there is a reference to the worksheet and a range? Like 'Sheet1'!$C$3:$h$5 ... I know at work I've seen references like this on maybe sheet 2, bringing that data over from sheet 1. Thanks again for your help, Dave

  5. #5
    Board Regular
    Join Date
    Feb 2002
    Posts
    202
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    But what is it called when there is a reference to the worksheet and a range? Like 'Sheet1'!$C$3:$h$5 ...
    this is an external reference. to do this, in a cell in one sheet type "=" (no quotes), then go to another sheet, click on a cell and press enter. you've just created an external reference.
    to get a range of cells as you've used in your example above, in your destination sheet select a range of cells the same size as the range you want to copy, type "=" into the formula bar, go to your source sheet, select the cells you want and press ctrl+shift+enter simultaneously.

    [ This Message was edited by: anno on 2002-04-16 23:28 ]

  6. #6
    New Member
    Join Date
    Jan 2013
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Copy a named range from one worksheet to another

    Thanks a lot for the info Anno

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •