• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How to create connection between two work books in Excel 2007

R

Ramani

New Member
Hi All,

Very Good Afternoon one & all.


I have one doubt i.e.,


I want to use values of test1.xls in test2.xls


I knew how to connect values between worksheets. But, I want to know how can we connect two work books.


Please help me.


Thanks in Advance!
 
Hi Ramani ,


To refer to one workbook from another , prefix the cell address with the tab name and the workbook name , enclosing the workbook name in square brackets [ and ].


For example , suppose we have a workbook named WB_A , having a tab name TAB_A , and we want a formula to refer to cell address ADDRESS_A ; in workbook B , in the relevant cell , enter the formula :


='[WB_A.xlsx]TAB_A'!ADDRESS_A


Narayan
 
You must log in or register to reply here.
Back
Top