Extracting numeric data from specific cells in excel

[cegun]

Hi, I would like to values from specific cells in excel file>>>>>>. Please help me with script to do that. for example, I would like to copy values from cells A1, A6, A11 up to A1501....and cells B1, B6, B11 upto B1501. Please note that the reoccurence could be more than the 5 cells in this example. That is it could be A1, A11, A21 (10 cells jump)...or A1, A33, A65,..(32 cells jump) etc. but in all cases reoccurence is always constant.



Thanks for helping

 

[Scott Huish]

Your link is broken. Where do you want to copy these values to exactly?

 

[cegun]

Your link is broken. Where do you want to copy these values to exactly?

Hi Scott,

I would like to copy into another sheet in the same workbook.
Lets say Sheet3

 

[Scott Huish]

Do you want to copy them to the same cells or to different cells?