Using Indirect function to skip columns from different worksheet

[AsherS]

A post about skipping rows is very similar to my situation, but I'm stuck on how to translate that for columns. (http://www.mrexcel.com/forum/showthread.php?t=77845)

I'd like to transfer information from a worksheet called "Raw Data" to another sheet, skipping every 5th column. I'd like to go from "Raw Data" B12 to a new sheet C6, then from "Raw Data" G12 to D6 in the new sheet, and so forth.

I figured out that I'll need to use COLUMN()*5-13 as a component of the function, but I can't seem to figure out how to format the name of the worksheet correctly, with the ampersand and quotation marks.

This doesn't work at all, but I think it's in the ballpark...

=INDIRECT("Raw Data!"(COLUMN()*5)-13)&12)

Can anyone help make this work?
Thanks!
Asher

 

[Jonmo1]

You're welcome.

 

[kerrimaharaj]

Hi. I have a similar problem. I have data going across columns and I'd like to select cells at intervals. But instead of filling right, I want to fill down.

How would I amend this formula to do that? If I copy down, the array formula changes to the next row, but the data I am trying to pull is in one row.

=INDEX(TaskData!13:13,(COLUMNS($A$1:A$1)-1)*4+38)

Thanks

 

[Joe4]

Hi. I have a similar problem. I have data going across columns and I'd like to select cells at intervals. But instead of filling right, I want to fill down.

How would I amend this formula to do that? If I copy down, the array formula changes to the next row, but the data I am trying to pull is in one row.

=INDEX(TaskData!13:13,(COLUMNS($A$1:A$1)-1)*4+38)

Thanks

You are probably better off posting your question to a new thread, instead of posting to a thread that hasn't been active in 6 years (especially since your question is a little different than the original one asked).

That way, it will appear in the "Unanswered threads" listing that people use to look for unanswered questions.