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