How to reference cells in another workbook?

  • Thread starter Thread starter path
  • Start date Start date
P

path

How do I reference cells in another workbook, within a
math formula? Thanks.
 
Hi
just open the second workbook. In the target workbook select your cell.
Enter the equatation sign '='. Now goto the second workbook and select
the reference cell.

without using this enter the following:
='C:\temp\[Book2.xls]Sheet1'!A1

Replace path, workbookname and tabname according to your environment
HTH
Frank
 
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

Reference to a Defined Name in another Workbook 1
How to copy formulas between workbooks w/0 referencing source? 1
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
How do I Reference another cell's content including its format 2
Link to another workbook 2
Excel Highlighting duplicates 0
Finding cells that contain references to other workbooks 2
Get location of match in another worksheet 2

Back
Top