![]() |
|
|
|
#1
|
|||
|
|||
|
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. |
|
#2
|
|||
|
|||
|
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 |