Simple VBA

[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?

 

[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

 

[Frank Kabel]

Hi
I would use
=OFFSET($H$8,(ROW(1:1)-1)*4,0)

 

[Betty Csehi]

Works great. Thanks so much!!