| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
copying every other row
Hi All
I have data in column A1 to A2564. I want to take every other line ie(A1, A3, A5, etc) and copy that to match the even columns in column B. ie (A2 would go into B1, A4 would go into B3, etc. So it is taking the value in every other line and copying it and moving it up one cell and over one cell. Thanks! Roy Example A1 1 A2 2 A3 3 A4 4 Result Al 1 B1 2 A2 now blank A3 3 B3 3 A4 blank now |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copying everything | New Users to Excel | |||
| copying the Hyperlink function result without copying the actual formula | Excel Worksheet Functions | |||
| copying | Excel Programming | |||
| TextBox copying not like windows copying, heh? | Excel Programming | |||
| Copying data down to next dirty cell, then copying that data | Excel Programming | |||
Threaded Mode
