Copying every other row
Hi,
Starting in cell C16 I need to copy every 3rd cell in column C until there
is no more data. How do I copy cell C16 , offset down 2 cells, copy again etc
etc until blank.
I then need to paste all these values into column C of another worksheet
("LFmacro.xls" sheet name "report") - BUT this worksheet already has data in
it so would need to paste into the next blank row (or leave a blank row and
paste into the next would be useful)
Can anyone help me?
|