+ Reply to Thread
Results 1 to 4 of 4

Simple Copy of Named Range to another sheet

  1. #1
    Registered User
    Join Date
    11-16-2011
    Location
    Tidewater VA
    MS-Off Ver
    Excel 2000
    Posts
    12

    Simple Copy of Named Range to another sheet

    I've looked through posts on named ranges, most are more advanced than the simple thing I want to do.

    I have a named range on one sheet, and I want to show this as a reference on other sheets. I thought this would be simple, but maybe it's just not the way named ranges are used.

    Attached is a sample spreadsheet. First tab shows the table defined; in practice it would be much larger. Second tab shows how I want it to appear. I see that I can do this by copying each cell reference. But what would be nice is to simply say "Put the named range block of cells right here."

    Sorry if this is truly too fundamental. I thought there would be some built-in function to do this without having to write some VBA code to accomplish what seems to be a fundamental, simple thing.

    I appreciate your taking a look at this.
    Attached Files Attached Files

  2. #2
    Administrator JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Simple Copy of Named Range to another sheet

    Put this lookup formula in A13, then copy down and across your table:

    =INDEX(DiskTable, ROW(A2), COLUMN(A1))
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    “None of us is as good as all of us” - Ray Kroc
    “Actually, I *am* a rocket scientist.” - JB (little ones count!)

  3. #3
    Registered User
    Join Date
    11-16-2011
    Location
    Tidewater VA
    MS-Off Ver
    Excel 2000
    Posts
    12

    Re: Simple Copy of Named Range to another sheet

    Quote Originally Posted by JBeaucaire View Post
    Put this lookup formula in A13, then copy down and across your table:

    =INDEX(DiskTable, ROW(A2), COLUMN(A1))
    Not sure if my other reply went through. But thank you.

  4. #4
    Administrator JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Simple Copy of Named Range to another sheet

    Thanks for the feedback. I have marked this thread solved for you.
    In the future please select Thread Tools from the menu above and mark the thread as solved. Thanks.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1