Linking workbooks

S

sleepy

I know how to link info from one cell into another workbook,
but how do I link info from 3 different cells into one cell on
another workbook?

Any help is appreciated
 
P

paul

=cell1&cell2&cell3.The & symbol lets you concatenate cells.You can use&" " if
you want a spacebetween.If you want to perform calculations the formulas are
exactly the same,but the references will be sheet1!A1 instead of just A1
so you could have =Sheet1!a1*sheet2!A1*sheet3!A1
 
Top