How to paste data to alternating cells down a column?

W

wbowers

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?
 
M

Max

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy corresponding cell in Column B if cell in A contains certain text? 1
copying column multiple times 0
Copy Indirect down a column 6
want to track time while paste value in multiple column of same roe 1
using the =page! feature to transpose a row to column 0
Multiple column search and Copy 7
Copying a cell ref. down a column, changing worksheet # along the 5
show last used cell in a column at the bottom of column. 3

Top