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?