Sequential Formula in VBA

[jap7675]

Hello,

I have this formula

=INDEX('Compliation 1600 Daily'!H3:H243, SMALL(IF(1='Compliation 1600 Daily'!F3:F243, ROW('Compliation 1600 Daily'!F3:F243)-ROW('Compliation 1600 Daily'!F3)+1),ROW('Compliation 1600 Daily'!1:1)))

That i would like to be able to copy into a row. However, i would like 'Compliation 1600 Daily'!1:1, 'Compliation 1600 Daily'!2:2, 'Compliation 1600 Daily'!3:3 ect. I would like this to continue up until a number defined in the 'Compliation 1600 Daily' spreadsheet.

Please Help!