Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to paste data to alternating cells down a column?
I am copying data from a column in one sheet where the entries run concurent
down the column. When I paste to the new sheet I need to paste the information in every other cell down the column. What is the best way to do this, I have 3600 entries copied in groups of 25 to 72 different sheets, each sheet holds 50 entries? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to paste data to alternating cells down a column?
One extraction technique which should serve you well ..
Assume you have source data in Sheet1, running in A2 down In another sheet, In any starting cell, say in B2: =IF(MOD(ROWS($1:1)-1,2)=1,"",OFFSET(Sheet1!$A$2,INT((ROWS($1:1)-1)/2),MOD(ROWS($1:1)-1,2))) Copy B2 down as far as required to extract Sheet1's source data into alternate cells all the way down. Freeze the values in col B with an "in-place" copy n paste special as values. Easily adapt the expression to suit where your source data starts, ie change the OFFSET's anchor: Sheet1!$A$2 Success ? Celebrate it, hit the YES below -- Max Singapore --- "wbowers" wrote: I am copying data from a column in one sheet where the entries run concurent down the column. When I paste to the new sheet I need to paste the information in every other cell down the column. What is the best way to do this, I have 3600 entries copied in groups of 25 to 72 different sheets, each sheet holds 50 entries? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Move alternating cells | Excel Discussion (Misc queries) | |||
Paste data to a filtered column, pasting to visible cells only | Excel Discussion (Misc queries) | |||
How to paste to alternating columns? | Excel Discussion (Misc queries) | |||
How to paste to alternating columns? | Excel Discussion (Misc queries) | |||
moving alternating rows to a column with the order staying the sam | Excel Discussion (Misc queries) |