Copying Excel Formulas
 

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?

Copying Excel Formulas
 

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

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

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Michasam" wrote in message
...
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?