Copy every nth cell across columns

[TMilner]

I have been trying to copy certain data that is arranged
consistently across columns where the data that I want to
put into a summary sheet would be from the same row but
every 7th column going to the right from cell A4. Is
there an easy way to do this? I have tried the every nth
row but it won't let me copy the first occurence of data
in my source sheet.

Thanks in advance for any advice,
TMilner

 

[Peo Sjoblom]

Use something like

=OFFSET(Sheet1!$A$4,,COLUMN(A4)*7-7)

copy across will give you A4, H4 and so on

if you want A4, G4 replace 7 by 6