Linking workbooks

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
=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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Linking to combo box selection 2
Excel Highlighting duplicates 0
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
update workbook links over network 1
Link To File That No Longer Exists 1
Linking a workbook to worksheets 1
Excel Protection 2
Finding cells that contain references to other workbooks 2

Back
Top