LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Bowbender
 
Posts: n/a
Default 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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Why is the order of my data table opposite from graph? mozermodo Charts and Charting in Excel 6 April 25th 23 03:43 AM
Increasing distance labels using drag down method Bowbender Excel Worksheet Functions 2 September 20th 05 09:25 PM
Data validation, cell protection or other method? KG Excel Discussion (Misc queries) 5 June 17th 05 05:22 AM
Import Data Keeps asking for Password Dominator Excel Discussion (Misc queries) 0 June 5th 05 11:25 PM
Running Data Table using an input that triggers DDE linked data [email protected] Excel Discussion (Misc queries) 1 December 16th 04 11:56 AM


All times are GMT +1. The time now is 07:18 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"