Copying Excel Formulas

M

Michasam

I have a spreadsheet of data that is set up kind of like a form in that, for
most of the data, I have 3 blank columns separating between each record. I
am trying to simply pull the data into another sheet using a formula that
references the cell in the original sheet.

Is there a way for me to copy the formulas across to where it only picks up
every fourth column?
 
R

RagDyer

Try this for copying Row1 from Sheet1 across columns, copying every 4th
column:

=INDEX(Sheet1!1:1,4*COLUMNS($A:A)-3)
 
Top