Thanks Kostis,

That works great!

I have used another formula to extract 2 piece of data from those specific
cells which occur before and after this text "--"

Those formulas a

For data before -- =LEFT(Sheet3!C2,FIND("--",Sheet3!C2)-1)
For data after --
=RIGHT(Sheet3!C2,(LEN(Sheet3!C2)-FIND("--",Sheet3!C2))-2)

Can you help me integrate your formula into these formulas?

Thanks again,
Brian


"vezerid" wrote in message
ups.com...
On Jun 6, 7:26 pm, "Brian" wrote:
Howdy All,

I want to get data from another worksheet, but the data I want occurs in
every 3rd row.

So I want data from C2, C5, C8, etc.

How can I do this in a formula so that when I drop the formula down, the
sequence will replace correctly?

Thanks,
Brian

In any cell (say B2):

=OFFSET('[otherbook.xls]sheetname'!$C$2,(ROW()-ROW($B$2))*3,0)

HTH
Kostis Vezerides