+ Reply to Thread
Results 1 to 1 of 1

Looping Mutliple Named Resized Ranges in next empty row below another named range

  1. #1
    Registered User
    Join Date
    03-19-2014
    Location
    Long Beach, CA
    MS-Off Ver
    MS Office 2010
    Posts
    1

    Looping Mutliple Named Resized Ranges in next empty row below another named range

    I have a created a consolidated listing of ranges that have column headings which I have named that are offset across rows horizontally. I am looking for a code to loop and copy based on a series of named headers to cells beneath a range with similar data. I have trying various looping, range offset, nextrow command without success. I don't really even need to utilize the range headings if the loop can take the two columns next to each other and increment until no header record is found. Any help would be greatly appreciated. I have been racking my brain and can't seem to find this exact scenario posted elsewhere with code I can adapt. I attached visuals to show my workbook. F:G is where I would want to paste below (for lack of better terminology). H:I,J:K,L:M, etc. are the groups where my the data needs to be pulled from.
    Attached Images Attached Images
    Last edited by gingumdog; 03-20-2014 at 11:48 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Combine all Named Ranges into one Named Range
    By thinkspac in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-23-2020, 07:52 PM
  2. [SOLVED] Determining if the value of a cell can be a named range, then assigning named ranges after
    By Romulo in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-15-2013, 06:05 PM
  3. I have 2 named ranges on 1 sheet and 1 named range on another..
    By niceguy21 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-05-2013, 06:08 AM
  4. Named ranges-Should I use a dynamic named range
    By foseco in forum Excel General
    Replies: 4
    Last Post: 06-11-2009, 03:56 PM
  5. [SOLVED] Named ranges-is there a an easy way to reference a single value in a named range?
    By pspkim@gmail.com in forum Excel General
    Replies: 1
    Last Post: 03-21-2006, 06:40 PM

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