Results 1 to 8 of 8

Dynamic named range for columns...moving one column over

Threaded View

  1. #1
    Forum Contributor
    Join Date
    12-12-2012
    Location
    Los Angeles
    MS-Off Ver
    Excel 2010
    Posts
    448

    Dynamic named range for columns...moving one column over

    Hello. I have a named range. I would like to have this named range automatically update to the right whenever new data is copied into the adjacent column to the right. Let's say I have Data in column A that I named "range". When I add data in the same cells in column B, I would like the range to update to include the cells in A and B (and only the adjacent cells, not the entire column). Is there any way to do this? I've attached a sample spreadsheet. Danks.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Dynamic named range for a column
    By amartino44 in forum Excel General
    Replies: 10
    Last Post: 08-28-2013, 04:49 PM
  2. dynamic named range across columns
    By amartino44 in forum Excel General
    Replies: 2
    Last Post: 08-19-2013, 03:02 PM
  3. [SOLVED] Need a Dynamic Named Range; Offset/Match using 2 Columns
    By Kalithro in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 08-18-2013, 06:54 AM
  4. Named Dynamic Range to count across columns not rows
    By talexander in forum Excel General
    Replies: 4
    Last Post: 01-04-2011, 11:07 AM
  5. Dynamic Named Range - Moving
    By jamesryan in forum Excel General
    Replies: 3
    Last Post: 05-01-2008, 08:53 AM

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