Need help.. excel formula

[Miloni]

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...

 

[schielrn]

Maybe you want something like:

=indirect("'[File A.xls]Orders - 2009'!$A" & row(a2)*2-1)

Note this formula will not work if the 2nd workbook is closed. You would need to look into the morefunc add-in for indirect.ext() for help with closed workbooks.

Hope that helps.

 

[Miloni]

This gives me an error...it doesnot work..

 

[schielrn]

It works for me, I added in a ' you were missing in the first formula, maybe you grabbed it before I got that in there?

 

[Miloni]

Thanks it worked well now....