I'm trying to select every third cell in a column in a different worksheet
than the one I'm using and I don't know if you can do this in Excel. E.g. I
want to reference in the current worksheet every third cell in another
worksheet. I want Excel to look down the column and select every third cell.
Can anyone help? It's difficult to ask the question. Thanks.

Hi,

are you trying to build a formula or what? And if a formula please show us
the formula you are trying to construct.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Tiger" wrote:

I'm trying to select every third cell in a column in a different worksheet
than the one I'm using and I don't know if you can do this in Excel. E.g. I
want to reference in the current worksheet every third cell in another
worksheet. I want Excel to look down the column and select every third cell.
Can anyone help? It's difficult to ask the question. Thanks.

I have a spreadsheet that has 2 worksheets, one called "Chart Feed" and the
other one called "Data Input". I am in the "Chart Feed" worksheet and I am
trying to reference every third cell in the 4th column of "Data Input". So,
my column on "Chart Feed" looks like this:

=+'Data Input'!D107
=+'Data Input'!D111
=+'Data Input'!D115
=+'Data Input'!D119

As you can see, I'm "grabbing" every third cell from the "D" Column in "Data
Input" worksheet. Right now I'm having to write each of these cells by hand.
It seems to me that there's a way I can ge Excel to grab the correct cell on
it's own. E.g. I tried writing =+'Data Input'!D(D107+3), and, off course, it
doesn't work. But there should be something like that.

Anyone has any ideas. And thanks so much

Tiger


"Shane Devenshire" wrote:

Hi,

are you trying to build a formula or what? And if a formula please show us
the formula you are trying to construct.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Tiger" wrote:

I'm trying to select every third cell in a column in a different worksheet
than the one I'm using and I don't know if you can do this in Excel. E.g. I
want to reference in the current worksheet every third cell in another
worksheet. I want Excel to look down the column and select every third cell.
Can anyone help? It's difficult to ask the question. Thanks.

Let's say you want to extract
what's in Sheet2's col A (in A1, A4, A7, etc) into Sheet1

In Sheet1, you could place this in any startcell,
say, in E2: =OFFSET(Sheet2!$A$1,ROWS($1:1)*3-3,)
then just copy E2 down as far as required

"Growl" your success here, click the YES button below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
"Tiger" wrote:
I'm trying to select every third cell in a column in a different worksheet
than the one I'm using and I don't know if you can do this in Excel. E.g. I
want to reference in the current worksheet every third cell in another
worksheet. I want Excel to look down the column and select every third cell.
Can anyone help? It's difficult to ask the question. Thanks.

I've just responsed earlier with a generic

With your specifics defined in your reply here
In your startcell, place this:
=OFFSET('Data Input'!$D$107,ROWS($1:1)*3-3,)
Then just copy it down as far as required
It'll return exactly what you're after

Celebrate your success, click the YES button below.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
"Tiger" wrote:
I have a spreadsheet that has 2 worksheets, one called "Chart Feed" and the
other one called "Data Input". I am in the "Chart Feed" worksheet and I am
trying to reference every third cell in the 4th column of "Data Input". So,
my column on "Chart Feed" looks like this:

=+'Data Input'!D107
=+'Data Input'!D111
=+'Data Input'!D115
=+'Data Input'!D119

As you can see, I'm "grabbing" every third cell from the "D" Column in "Data
Input" worksheet. Right now I'm having to write each of these cells by hand.
It seems to me that there's a way I can ge Excel to grab the correct cell on
it's own. E.g. I tried writing =+'Data Input'!D(D107+3), and, off course, it
doesn't work. But there should be something like that.

Anyone has any ideas. And thanks so much

=INDEX('Data Input'!$D$107:$D$1000,(ROWS($1:1)-1)*4+1)

copy down


"Tiger" wrote:

I have a spreadsheet that has 2 worksheets, one called "Chart Feed" and the
other one called "Data Input". I am in the "Chart Feed" worksheet and I am
trying to reference every third cell in the 4th column of "Data Input". So,
my column on "Chart Feed" looks like this:

=+'Data Input'!D107
=+'Data Input'!D111
=+'Data Input'!D115
=+'Data Input'!D119

As you can see, I'm "grabbing" every third cell from the "D" Column in "Data
Input" worksheet. Right now I'm having to write each of these cells by hand.
It seems to me that there's a way I can ge Excel to grab the correct cell on
it's own. E.g. I tried writing =+'Data Input'!D(D107+3), and, off course, it
doesn't work. But there should be something like that.

Anyone has any ideas. And thanks so much

Tiger


"Shane Devenshire" wrote:

Hi,

are you trying to build a formula or what? And if a formula please show us
the formula you are trying to construct.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Tiger" wrote:

I'm trying to select every third cell in a column in a different worksheet
than the one I'm using and I don't know if you can do this in Excel. E.g. I
want to reference in the current worksheet every third cell in another
worksheet. I want Excel to look down the column and select every third cell.
Can anyone help? It's difficult to ask the question. Thanks.

Hi,

Try this

=INDIRECT("'Data Input'!D"&103+ROW(A1)*4)

A little sidebar: you don't need to type =+ Just type = its quicker, and
your spreadsheet is smaller and who knows maybe it even calculates faster.

Both INDEX and OFFSET can also be used.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Tiger" wrote:

I have a spreadsheet that has 2 worksheets, one called "Chart Feed" and the
other one called "Data Input". I am in the "Chart Feed" worksheet and I am
trying to reference every third cell in the 4th column of "Data Input". So,
my column on "Chart Feed" looks like this:

=+'Data Input'!D107
=+'Data Input'!D111
=+'Data Input'!D115
=+'Data Input'!D119

As you can see, I'm "grabbing" every third cell from the "D" Column in "Data
Input" worksheet. Right now I'm having to write each of these cells by hand.
It seems to me that there's a way I can ge Excel to grab the correct cell on
it's own. E.g. I tried writing =+'Data Input'!D(D107+3), and, off course, it
doesn't work. But there should be something like that.

Anyone has any ideas. And thanks so much

Tiger


"Shane Devenshire" wrote:

Hi,

are you trying to build a formula or what? And if a formula please show us
the formula you are trying to construct.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Tiger" wrote:

I'm trying to select every third cell in a column in a different worksheet
than the one I'm using and I don't know if you can do this in Excel. E.g. I
want to reference in the current worksheet every third cell in another
worksheet. I want Excel to look down the column and select every third cell.
Can anyone help? It's difficult to ask the question. Thanks.

Correction. Looks like it should have been "4" in the expression:
=OFFSET('Data Input'!$D$107,ROWS($1:1)*4-4,)

Think I was misled earlier by your descript: "every 3rd cell"
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---