Hi,

 

Can I linlk cells from different workbook? (call reference to other work book). E.g I have two work books. orange.xlsx and mango.xlsx. both have sheets named like orangesheet1, orangesheet2...mangosheet1, mangosheet2 etc.

 

My question is how can I link cell B5 in orangesheet1 to cell D70 in mangosheet2

 

This is done in excel some what like entering formula in B5, =[mango.xlsx]mangosheet2!D70

 

Can you please explain.

 

Thanks in advance

Shesh