paste data in different sheet but skip rows.
 

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

paste data in different sheet but skip rows.
 

Carmel,

In sheet2, cell A7, enter

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

and copy down as far as you need.

HTH,
Bernie
MS Excel MVP


"CarmK" wrote in message
...
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

paste data in different sheet but skip rows.
 

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! :-)

"Bernie Deitrick" wrote:

Carmel,

In sheet2, cell A7, enter

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

and copy down as far as you need.

HTH,
Bernie
MS Excel MVP


"CarmK" wrote in message
...
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