Microsoft Office Forums - View Single Post - [Solved] Copying Every Other Row from one workbook to another.

Thread: [Solved] Copying Every Other Row from one workbook to another.

View Single Post

Old

04-07-2017, 03:30 PM

jeffreybrown jeffreybrown is offline

jeffreybrown is offline

jeffreybrown uses Windows Vista

Windows Vista jeffreybrown uses Office 2007

jeffreybrown uses Office 2007

Office 2007

Expert

Join Date: Apr 2016

Posts: 673

jeffreybrown has a spectacular aura about

jeffreybrown has a spectacular aura about

Default

In A2 of Book2 and copied down...

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

Reply With Quote