I am trying to retrieve data from File A to File B. File A has large database and File B should keep updating as soon as something is added in File A. I tried the following formula : =[File A.xls]Orders - 2009'!$A3. This formula is entered in File B -- Cell A5. Now in Fill B -- Cell A6, I want the following formula: =[File A.xls]Orders - 2009'!$A5. This kind of formula will go on for about 1500 rows of Col A. The best part is that it has to take every alternate row of Col A in File A. i.e. 1st it's A3..A5..A7..A9..A11 and so on.. how do I set up a formula in each cell (without typing them) and just trying to pull the formula down thru all 1500 rows of Col A.
Any help with formula...
Any help with formula...