Excel formulas

[daginge]

Hi ABers
I need to combine info from 3 excel sheets in separate workbooks and show an overview in a fourth any ideas?
TIA

[scotman]

You need to look up Help file info on Linking Workbooks

[ChuckFickens]

You just have to precede the cell reference with the worksheet name in any formulas.

http://www.homeandlea...07/excel2007s8p7.html

[Calibax]

e.g. =Sheet1!A1+Sheet2!A1+Sheet3!A1
will sum cell a1 from 3 separate sheets

[daginge]

Thanks Guys, I think the best way would be to put the 3 sheets into a single workbook and combine in a single sheet, this all seems V complicado!