looping and copying from onesheet to othersheet
 

my data is as follows in excel sheet

Subcd MeasCd Year Month Date Value
33 99 04 4 34
33 99 04 5 38
and so on till next year 3March
36 99 04 4 45
36 99 04 5 32
and so on till next year March
33 71 04 32
and so on

I am trying to create a loop on measCd till the value of Meascd and subCd
remains the same .After that this data needs to go in a diff sheet rowwise.
The data mentioned above is coming from Oracle data base via ASP page.
But After that I am struggling to get the loops and then pulling the data
back

Any help would be appreciated
--
Kittie