paste data in different sheet but skip rows.

C

CarmK

Hi,

I would like to copy a column of names from one sheet to another but would
like to paste the data into every second row.

i.e. Sheet1!A7 goes to Sheet2!A7 ; Sheet1!A8 goes to Sheet2!A9 ; Sheet1!A9
goes to Sheet2!A11 etc.

I have seen similar posts / answers using the INDEX formula but can't work
out how to make it work for me!

Any help would be much appreciated!

Thanks
Carmel
 
B

Bernie Deitrick

Carmel,

In sheet2, cell A7, enter

=IF(MOD(ROW(),2)=1,INDEX(Sheet1!$A$7:$A$5000,ROW(A2)/2),"")

and copy down as far as you need.

HTH,
Bernie
MS Excel MVP
 
C

CarmK

Wow, that was fantastic! Thanks a million!! You have saved me hours of work!

Now all I need to do is work out How that works! :)
 

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

Columna to Rows Formula 9
paste to different rows on different dates 3
Selective rows from one sheet to another 8
copy data from sheet2 to sheet1 when sheet2 has variable # of rows 6
Data Validation in another sheet 1
Lock Hyperlink to cell in different sheet 6
Conditional sum in a named range 8
VB macros issue with selecting cells on different page 1

Top