Copy every nth cell across columns

  • Thread starter Thread starter TMilner
  • Start date Start date
T

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
 
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
 
Back
Top