VBA to paste data into particular rows

[Jovillanueva]

Hi,

I have created 3 different select statement (query) with different where clause critera. The first query wil start copying in row 2 until row 199. Second query will dump the data starting row 201 up to 399 while the last query will dump the data from row 401 up to 599. May I ask your help on how to do this in vba excel. your hlp is very much appreciated. thank you.

Please Login or Register  to view this content.

[Jovillanueva]

Hi, This is the codes i have done, so far the result that i wanted to be was successfull. Is there any simple solution that would give the same result with my requirements? thanks.

Below is my vba macro code

Please Login or Register  to view this content.