Drag down method for getting data from another worksheet at every Nth cell
 

Here is the deal. I have a worksheet, lets call it Sheet1 that has a
ton of data (25,000 entries). I want gather every 20th cell in column
B from there and put it into lets say Sheet2 so that the data in the
Sheet2 has the following.

=Sheet1!B20
=Sheet1!B40
=Sheet1!B60

I relize that I can type these all in by hand but due to the very large
number of cells I would be working on this till next week. Any help
from the generous people here would greatly be appreciated.

If there is an alternative to the drag down method, I am all for it.

Thanks

I put this in A1 and dragged down:

=INDIRECT("sheet1!b"&ROW()*20)

until I ran out of data.

Bowbender wrote:

Here is the deal. I have a worksheet, lets call it Sheet1 that has a
ton of data (25,000 entries). I want gather every 20th cell in column
B from there and put it into lets say Sheet2 so that the data in the
Sheet2 has the following.

=Sheet1!B20
=Sheet1!B40
=Sheet1!B60

I relize that I can type these all in by hand but due to the very large
number of cells I would be working on this till next week. Any help
from the generous people here would greatly be appreciated.

If there is an alternative to the drag down method, I am all for it.

Thanks

--

Dave Peterson

Dave,

I didn't have any success with that. I keep getting #Ref error. Here
is my actual formula.

=INDIRECT(Results!B20&ROW()*20)

The data in the Results!B20 cell is a number, in this case 0.0989

When I drag down, I want the next cell to be

=INDIRECT(Results!B40&ROW()*20) or the equivelant that will make it
refer to cell B40, B60, B80, etc... in my Results worksheet.

Thanks for the help.

=INDIRECT("Results!B"&ROW()*20)

"Bowbender" wrote:

Dave,

I didn't have any success with that. I keep getting #Ref error. Here
is my actual formula.

=INDIRECT(Results!B20&ROW()*20)

The data in the Results!B20 cell is a number, in this case 0.0989

When I drag down, I want the next cell to be

=INDIRECT(Results!B40&ROW()*20) or the equivelant that will make it
refer to cell B40, B60, B80, etc... in my Results worksheet.

Thanks for the help.

What happens if I insert a new row 1? <g

Biff

"Dave Peterson" wrote in message
...
I put this in A1 and dragged down:

=INDIRECT("sheet1!b"&ROW()*20)

until I ran out of data.

Bowbender wrote:

Here is the deal. I have a worksheet, lets call it Sheet1 that has a
ton of data (25,000 entries). I want gather every 20th cell in column
B from there and put it into lets say Sheet2 so that the data in the
Sheet2 has the following.

=Sheet1!B20
=Sheet1!B40
=Sheet1!B60

I relize that I can type these all in by hand but due to the very large
number of cells I would be working on this till next week. Any help
from the generous people here would greatly be appreciated.

If there is an alternative to the drag down method, I am all for it.

Thanks

--

Dave Peterson

If you insert it in a different worksheet in a different workbook, then nothing!

(Sometimes people use it, sometimes, they don't!)

Biff wrote:

What happens if I insert a new row 1? <g

Biff

"Dave Peterson" wrote in message
...
I put this in A1 and dragged down:

=INDIRECT("sheet1!b"&ROW()*20)

until I ran out of data.

Bowbender wrote:

Here is the deal. I have a worksheet, lets call it Sheet1 that has a
ton of data (25,000 entries). I want gather every 20th cell in column
B from there and put it into lets say Sheet2 so that the data in the
Sheet2 has the following.

=Sheet1!B20
=Sheet1!B40
=Sheet1!B60

I relize that I can type these all in by hand but due to the very large
number of cells I would be working on this till next week. Any help
from the generous people here would greatly be appreciated.

If there is an alternative to the drag down method, I am all for it.

Thanks

--

Dave Peterson

--

Dave Peterson