Copy every nth cell across columns

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

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

--

Regards,

Peo Sjoblom


"TMilner" wrote in message
...
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