Simple VBA

B

Betty Csehi

I have data in column H8 - H647. I want to copy what is in cell H8 to cell
L1. I then want to copy every 4th cell after that. So..... cell L1= H8,
L2=H12, L3=H16, etc.

I think this is a pretty simple task but I don't have a clue as to how to do
it. Can someone help?
 
A

Alex

Betty

Try this. In cell L1 type...

=OFFSET(L1,ROW(L1)*3+4,-4)

No just drag down as far as you need to go.

I think this ought to work. Let me know if it doesn't...

Regards


Alex
 
Top