Looping through 2 different variable for different result

[calvinle]

Hi,

I wonder how to loop and control throught 2 different variables?

Please Login or Register  to view this content.

I mainly want the macro to do:

Please Login or Register  to view this content.

Do not consider the rngList.Cells, but more the mathematical way.

Thanks.

[HaHoBe]

Hi, calvinle,

maybe

Please Login or Register  to view this content.

Ciao,
Holger

[calvinle]

That won't work because lngid ahould repeat 6 to 10 then repeat 6 to 10.

[HaHoBe]

Hi, calvinle,

you would need to attach a workbook as your explanation and the code provided do hardly match up at least leave aa lot of questions open on my part.

Sorry for the code it should read like

Please Login or Register  to view this content.

I don´t know what went wrong when copying the code over here (must have been the wrong origin apparently).

Ciao,
Holger

[calvinle]

Hi,

Thanks for willing to help me because I spent days trying to figure out this thing. I cannot upload a sample is because my vba is calling (getting data) from an external apps which you don't have.

But here is the one that work so far but only for 1 page. If my client have 2 pages, I don't know how to change the value for the same action.

Here is the one that work so far but only if the client have 1 page of data. If the client has more page of data, I will need to bring repeat this, however, the code:
rngList.Cells(lngSrcIdx, 1).Value -> has to be the next empty row, otherwise it will just copy and paste the next page data on these same row (6 to 18)

Please Login or Register  to view this content.

This code work for 1 page, so if my client has 2 pages, I will need to copy and paste the code right next below:

Please Login or Register  to view this content.

But in this one, the code will be place in row 6 to 18, and then go to page 2, and replace the data to 6 to 18, which I don't want. I want the data to be placed in 19 to 31...

And if my client has 10 pages, I will need to find a way to do so for 31 till end row.

Thanks for heping.