Loop through range names for location of dynamic paste

Key points,

- I am currently importing tabular data from anywhere between 5 and 7 worksheets.
- I am grabbing the data from each and pasting (end(x1up)) to a single dump worksheet.
- I am then using a Do While Loop to analyze for instances of two strings (using inStr - the beginning and end of a selected range).
- Once this range is selected, I am stair-stepping down and to the right for my paste by a factor of 17 columns and 100 rows.

Here's the code:

Please Login or Register  to view this content.

**Request**
I have since named 6 ranges that I would like to loop through to tell excel where I want each subsequent range pasted after analysis and selection.cut. The ultimate goal is to have the data pasted to the same place everytime regardless of the dynamic nature of the imported data. The ranges are A_1, B_1, C_1, A_2, B_2, and C_2.

THANK YOU!

Could you possibly provide me with an example of how to incorporate into the provided code?

Thanks Dave. I have simplified down to a vanilla example. ABCD populate A1:A4. B1:B4 is a named range containing the string text of 4 other named ranges in the worksheet (C5, D6, E7, and F8, respectively. I need to loop through the first, cut it, and paste it to the range indicated in the second loop.

Ultimately C5="A", D6="B", E7="C", and F8="D"

My effort is included in Module 1.