Excel Formulas for Linking Data between Different Sheets

5 comments
  • trainerslisting com 02/25/2011, 5:39 AM Reply

    The post is a very good way for someone who wants to link data in excel between different sheets. I used the post for my FRM preparation and it worked wonders.

  • Joe 02/25/2011, 10:53 AM Reply

    I am glad it helped

  • Naveed 07/28/2011, 11:58 AM Reply

    Hi
    I have a problem and I have been actually getting around it manually for past two days but its just 2 much to do…I know the solution mite be basic but I am a begginer with excel. Here is the problem.
    I have 2 workbooks.
    Work book 1 contains Purchase orders for all transactions and a column which has the goods recieved date for the particular purchase order. about 5000 such transactions.
    workbook 2 contains some of these purchase orders,about 1000, but no goods recieved column.So what I want is that a column is created in which the corrosponding goods recieved date is printed infront of the related purchase order from the data in workbook 1. hope my question is clear. Thanks.

  • Calvin 08/21/2012, 2:23 AM Reply

    Very helpful. Now I am wondering if I can do this… and utilize sorting throughout my sheets. Say we have this example… now we want to sort by which budget has the most remaining. That is what I am wondering how to do.

  • Jynn 12/01/2012, 8:28 AM Reply

    I need some help. I currently have 2 worksheets linked together. The “recap” sheets calculates the revenue, the “invoice” sheet takes the data from the “recap” tab and prepares the actual invoice. The problem is the cells have “=recap!D6″ with the amount. The system is reading “=recap!D6″ instead of the amount. Is there a way to link the worksheets without the “=recap!D6″?

Leave a Comment

*