Copying Every Other Row from one workbook to another.

		Microsoft Office Forums > Microsoft Excel > Excel
Copying Every Other Row from one workbook to another.

04-07-2017, 03:30 PM

jeffreybrown jeffreybrown is offline

Windows Vista Copying Every Other Row from one workbook to another.

Office 2007

Expert

Join Date: Apr 2016

Posts: 673

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

Other Forums: Access Forums

All times are GMT -7. The time now is 05:20 AM.