How to copy every Nth column to a new sheet

C

Ceywood

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

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

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

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

Thanks very much
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to Import Formatted text as new Slides in PowerPoint 0
Export tracked changes to a new document 0
How to center adjust text above and image in a two column document. 1
How can the font and size of (all) citation numbers be altered? 1
How to display the merge function "url" of a picture? 0
Visio: copy text of a master shape to User-define Cells (Variable) 0
Copy values for every nth cell 7
Macro to select and delete levels of a document 2

Top