How do I create mathematical links from workbook to workbook?

  • Thread starter Thread starter Shoobiloo
  • Start date Start date
S

Shoobiloo

I have 3 workbooks. I want to add numbers from workbook 1 and workbook 2 into
a total in workbook 3. Is there a way to do this? If so, how?
 
Thanks. However I am getting an invalid cell error. I am typing in the
numbers/letters from the cells I want to add using the name of the books and
sheets as you indicate below. If the cells I'm trying to add and place in
another workbook are part of a column that contains an addition function,
would that matter? Help!

Bernard Liengme said:
=[Book3]Sheet1!$D$1+[Book4]Sheet1!$E$1
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

Shoobiloo said:
I have 3 workbooks. I want to add numbers from workbook 1 and workbook 2
into
a total in workbook 3. Is there a way to do this? If so, how?
Click to expand...
Click to expand...
 
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

Excel Protection 2
Scattered array cells copy to scattered array cells another workbook 14
COM addin won't connect when workbook opened via another workbookfrom another instance 3
How to append data from different sheet and different workbook? 2
Save As and new workbook new name used in existing code 8
How to reference a cell from anther workbook without opening it 0
VBA code for pasting links -- modifying RDB code for summary workbook 10
Import multiple workbooks to current workbook in specified row number 0

Back
Top