Loop Question

[ej463]

I have cells in A1 - A20. I have an excel loop that takes each cell from A1 - A20 looks up information on the internet and pastes data in the corresponding row in B1 - B20. I would like to run this loop continuously because there are timely fluctuations in this data procured from the internet. If i run this loop continuously it will just overwrite the old data, I would like to preserve the old data. What i was wondering if after the loop ends copy A1 - A20 to A21 - A40, the loop starts and looks up information on the internet for A1 - A20 but instead pastes it in the corresponding row in B21 - 40, and once the loop is over. Copy A1 - A20 to A41 - A60, loop starts again and looks up information for A1 - A20 and pastes it in the corresponding row in B41 - B60, and so on I would like to run to have this repeat about 2000+ times. Would appreciate help.

[ravishankar]

Hi
If you can share the code you are using to download from the net, appropriate changes can be made to append data after each cycle.
Ravi

[JBeaucaire]

You can't do it more than 254 times since there are only 256 columns in Excel 2003 as shown in your profile.

Please Login or Register  to view this content.

[Paul]

If he went down rows instead of across columns, though (as he suggested originally), he could easily handle 3000+ iterations.