Return the value of a complex formula

[WaterChild]

PLESSE NOTE I AM USING EXCEL FOR MAC

I have created a formula which looks up data points from a number of separate workbooks. The reason is that I have about 2,000 specific cells that I need to combine in 1 sheet.

Cell: B10
="='["&$B$3&"_"&B$4&".xlsx]"&$B$1&"'!"&B$8&$A10

The formula works perfectly, however, when I copy and paste the formula into a separate cell I get the formula and not the result.

Cell: I10
='[AFOLU_2000.xlsx]3A1 DairyCowsCH4'!A10

In order for me to generate the result I need to go into the cell (I10) and press enter.

The issue is that I would need to enter the cell and press enter for 2,000 cells.

Does anyone have a solution for this. I am using Excel for Mac and therefore the "SendKeys" command will not work.

 

[bobhc]

PLESSE NOTE I AM USING EXCEL FOR MAC

And the Mac help sites said what? As this is a site for pc based Excel you will be very limited in any help as not many will know of the differences between the two.



https://www.google.co.uk/search?q=h...t=firefox-b&gfe_rd=cr&ei=eG3ZV9_cHpCFaM_mtMAJ


.

 

[WaterChild]

Many thanks. I have posted the question on the MS MAC specific site. I appreciate your guidance on this.

 

[vletm]

... do You really have a dream to 'copy' those formulas to 2'000 times?
... and why ... 2*2'000 same formulas?
if so
... check Your formulas one more time
... active cell, take right bottom corner and pull down for few cells
... check results >> modify if needed You formulas
This method works in Mac too.