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.
Bookmarks