Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Why is the order of my data table opposite from graph? | Charts and Charting in Excel | |||
Increasing distance labels using drag down method | Excel Worksheet Functions | |||
Data validation, cell protection or other method? | Excel Discussion (Misc queries) | |||
Import Data Keeps asking for Password | Excel Discussion (Misc queries) | |||
Running Data Table using an input that triggers DDE linked data | Excel Discussion (Misc queries) |