Thread: How to copy every Nth column to a new sheet
View Single Post
  #2   Report Post  
Ceywood Ceywood is offline
Junior Member
  
Posts: 2
Default
Actually - after much trial and error I think I've just solved this:

=INDEX(Me6TrenZnCu!$B1:$BRL1,8*(COLUMNS($A$1:A$1)-1)+1)

(The sheet with all the raw data is called Me6TrenZnCu adn the data goes out to column BRL.)

Cheers!
Reply With QuoteReply With Quote