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?

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" <(E-Mail Removed)> wrote in message
news:3769908B-D6F8-4DFB-A667-(E-Mail Removed)...
>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?