Copying Every Other Row from one workbook to another.

eleno5485 · #1 04-07-2017, 01:28 PM

I need a formula that will tell Book 2 to copy rows 1, 3, 5, 7, 9, etc. from Book 1 into rows 2, 4, 6, 8, 10 of book 2.

jeffreybrown · #2 04-07-2017, 03:30 PM

In A2 of Book2 and copied down...

=IF(MOD(ROW(),2)=0,[Book1.xlsx]Sheet1!A1,"")

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
data entered in one workbook should be updated in other relevant workbook based on the date	vedha	Excel	0	04-24-2015 08:45 PM
How to add attached excel workbook with hyperlink in the same workbook	lynchbro	Excel Programming	0	02-24-2015 01:29 PM
Range(Cell1,Cell2) Error on another workbook controlling some other workbook?	tinfanide	Excel Programming	1	02-09-2012 04:08 PM
macro to transfer data from one workbook to another workbook	virsojour	Excel Programming	5	02-01-2011 08:58 PM
Select a range in one one workbook while working in other workbook	Slow&Steady	Excel	1	02-21-2010 03:34 AM