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
|