Results 1 to 5 of 5

Mirroring Named Ranges

Threaded View

  1. #1
    Registered User
    Join Date
    08-25-2009
    Location
    Kansas City
    MS-Off Ver
    Excel 2003
    Posts
    3

    Mirroring Named Ranges

    Forum newbie here.... for this problem I am working within one worksheet. This worksheet contains 20 different datasets which are divided into separate 30 x 10 grids, all of which help comprise a larger 300 x 20 grid. I have defined each smaller grid/dataset as its own named range. Originally the entire dataset started in A1, but I am shifting it dataset down by 40 lines to create space to work at the top of my workbook.

    I am wanting to create a data validation list in A1, then have cells A3:J32 populate with the named range I select in A1. However I also want this populated dataset at the top of the sheet to be a mirror -- not a copy. Therefore once I have the data in my range available A3:J32, anything I manipulate would be mirrored in the original range in the lower portion of the workbook.

    Any advice would be appreciated. Thanks for looking!
    Last edited by wjcjhwk; 08-26-2009 at 12:49 PM.

Thread Information

Users Browsing this Thread

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

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