If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Pasting Columns
I have a list of names in a column (for example A1:A100) and would like to
paste it into another worksheet; but in a way that it skips every other cell. (A1-A200) Not sure if it is possible. Any ideas?? |
#2
|
|||
|
|||
paste it into the new worksheet
next to in enter 1 to 100 (in 1 increments) below the new numbers enter 1.5 to 100.5 (in 1 increments) select both columns and sort by the number column delete the number column the names will be in every other row "Humbertt" wrote: I have a list of names in a column (for example A1:A100) and would like to paste it into another worksheet; but in a way that it skips every other cell. (A1-A200) Not sure if it is possible. Any ideas?? |
#3
|
|||
|
|||
use a helper column. with uneven numbers 1,3,5,7,9 up to 201 followed by even numbers 2,4,6,8,up to 200 paste your names into a column next to the even numbers highlight the whole area including the even numbers and sort using the numbers column. -- bill k ------------------------------------------------------------------------ bill k's Profile: http://www.excelforum.com/member.php...nfo&userid=821 View this thread: http://www.excelforum.com/showthread...hreadid=468009 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Received vs. Sent Columns | Bill G | General Discussion | 2 | March 9th, 2005 04:17 PM |
Update Right & Left Columns | G. Edwards | Running & Setting Up Queries | 1 | March 3rd, 2005 04:23 PM |
Want to combine columns and horizontal lines in complex chart - Can it be Done?! | James Hobart | Charts and Charting | 3 | February 18th, 2005 02:23 AM |
creating matching data in different columns | Tig | General Discussion | 6 | August 13th, 2004 04:26 AM |
Displayed Rows and Columns Excel 2000 | Roy | Worksheet Functions | 2 | April 14th, 2004 05:11 PM |