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.
I am glad it helped
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.
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.
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
Replies to my comments
Notify me of followup comments via e-mail. You can also subscribe without commenting.