• 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.

getting info from one book to another

B

buttyman

New Member
Hi there could some one tell mell me the formula to transfer information from one book to another on an ongoing basis or does it have to be in the same work book. for example i have used the formula ='january 13'!T4 and its transfers ok but it doesn't carry on when i update info on the first book it doesn't add it in to the second book. I am a novice at formula so i hope some understands my explanation
 
Hi ,


The formula you have posted is a reference to a cell in a worksheet within one workbook ; 'january 13' refers to a sheet tab , while T4 refers to a cell.


To reference a cell in another workbook , you need to include the full file name of the other workbook.


For more details , refer to the following links :


1. http://office.microsoft.com/en-us/excel-help/create-an-external-reference-link-to-a-cell-range-in-another-workbook-HP010342364.aspx


2. http://www.quepublishing.com/articles/article.aspx?p=1594811&seqNum=8


Narayan
 
Thanks for the info got there in the end very useful and keep up the good work once a gain thanks

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