Results 1 to 8 of 8

Dynamic Range Names

Threaded View

  1. #1
    Forum Contributor
    Join Date
    04-02-2008
    Location
    Jacksonville Beach, Florida
    MS-Off Ver
    Microsoft Excel 2003 and 2010
    Posts
    264

    Dynamic Range Names

    Looking to create three dynamic ranges that move based on field 1 of the attached spreadsheet sample.

    The first range would be named "Blue", the second "Red" and the third "Green". Each day, new data will populate this same sheet (in the same format), only there will be a different number of rows for each color (sometimes less, sometimes more). What is the formula to create these dynamic ranges? If you can tell me how to do one of them, I can likely figure out the other two.

    Thanks greatly, in advanced. This will really help me.

    D
    Attached Files Attached Files
    ______________________________________
    "Vision without Execution is a Hallucination"
    Edison

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Trouble referring to dynamic names in a Range
    By BeefNoodleSoup in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-27-2011, 01:51 AM
  2. Dynamic range names
    By icegood in forum Excel General
    Replies: 2
    Last Post: 02-23-2011, 12:30 PM
  3. [SOLVED] dynamic range names in Edit -> Go to
    By Tim Marsh in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-23-2006, 08:50 AM
  4. Dynamic Range Names For a Graph
    By whiZZfiZZ in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-16-2006, 01:45 PM
  5. [SOLVED] Question for use of offset and range:Dynamic names
    By Bob Phillips in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-06-2005, 07:05 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