Copy Cells - Thanks

[oldspice]

I am trying to copy the values at every 14th cell such as A14, A28, A42...and paste the values on another worksheet in conseq. order.

Any suggestions?

Thanks in advance.

[tonywig]

How about flagging all the rows/cells to be copied from your original sheet to indicate that they are on a row that is a multiple of 14.

Something like ...
=IF(CELL("row",A1)/14 = INT(CELL("row",A1)/14),1,0)
... where A1 is the cell you wish to copy.

Then copy the whole lot onto your target sheet, sort them on the newly created "marker" and everything that WAS on a row that was a multiple of 14 is now together.

If you need to retain the original sequence, add another marker indicating the original row (from your source sheet) ...
=CELL("row",A1)
... and then sort on the "14 marker" and then the "original row" marker.

Not sure I have explained this too well - hope it is of help.