Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old August 30th 12, 06:59 AM
Junior Member
 
First recorded activity by ExcelBanter: Aug 2012
Posts: 2
Default How to copy every Nth column to a new sheet

Hi everyone - apologies in advance, I am completely ignorant about excel outside of the really basic!

I'm currently trying to analyse a huge amount of data (each file contains a minimum of columns A -- BRL) and I'm trying to extract certain columns to the next sheet to simplify the analysis. For one example in the original sheet "Raw Data" I need the contents of column B (starting from cell B1) and then every 8th column after that (J, R, Z etc) and copy them into Sheet 1.

I'm unsure if I should be using the indirect or index function for this (or something else!). If possible I'd like to avoid using VBL or making macros.

I've done a lot of net surfing to try and find a solution but everyone's doing something slightly different and most posts provide the equation without an explanation of what each part of the code means. I'll have other files that will require slightly different column manipulations (eg copying every 12th column starting from column F etc), so if anyone has time to provide a brief explanation with the answer I'd be extremely grateful. (In the last months of a PhD and this data analysis stands between me and the END!)

Thanks very much.

  #2   Report Post  
Old August 30th 12, 08:23 AM
Junior Member
 
First recorded activity by ExcelBanter: Aug 2012
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
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Code to copy column in sheet 1 to column in sheet 2 based on matched criteria skitsoni Excel Programming 1 July 14th 12 11:25 AM
Match value from column A to column A on 2nd sheet and then copy R DanS Excel Programming 2 February 16th 09 09:03 PM
How to search column, copy row, and copy to another sheet in same Rockhound Excel Discussion (Misc queries) 1 December 9th 06 04:16 PM
how to make one column copy from one sheet to anoth column w/o zer areezm Excel Discussion (Misc queries) 3 June 6th 06 10:45 PM
Copy column from one sheet to another Jacquie Excel Discussion (Misc queries) 1 December 5th 05 09:57 PM


All times are GMT +1. The time now is 12:29 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017