Expert needed

[SQUIDD]

Hello everyone

I have some code written that does what it is meant ot do.
The process.

• First it uses numbers that i enter into sheet NUMBERS column A starting at A1 to do a web query.
• Then it uses the data that is returned to do 6 more web querys on different sheets.
• then it copy's and pastes relevant info from all this data into sheet data starting at A1 and finishing at A39.(the data is 39 rows long)

what i need to do is make it do this process again once it has finished but use the next cell down in sheet NUMBERS which would be A2, it would then run my processes as described above and copy and paste the relevant info into sheet data but starting at A40 and finishing at A79.(This number is a constant +40).

The cycle would end if there are no more numbers in column A on sheet NUMBERS.

Any one know if this can be done, i know i could write the code several times but I have about 2500 numbers to put into Sheet NUMBERS.

So some sort of loop would be very handy.

Thankyou in advance,

Dave

 

[gecs]

Posting the code will be of some help because you need to call that procedure in another macro nesting the cycle from A1 to 2500 (or whatever number of rows you have there in the NUMBERS sheet) and make it write in the other sheet based on the "constant +40" as you said. In this respect the procedure you have must be "upgraded" with some more parameters (at least two, or maybe not, but we can't know this unless you post the code) and maybe (not sure though) needs some minor adjustments to use those extra parameters (or not ... who knows?).

 

[SQUIDD]

Thankyou for your response.
I have posted this code before so i hope it dosent cause a problem, i think i will just link it to my first post, i had no answer there.

Here is the link

http://www.mrexcel.com/forum/showthread.php?t=378540

If it wont cause a problem i will post it here.

Thankyou

Dave

 

[Smitty]

Please continue in that post.

If you feel your post has been ignored, you can always respond to it with "BUMP" to move it up in the page ranks.