In 2013, it is very easy to copy data from one workbook to another and Paste As Link.
But how do I do link one table to the contents of a table in another workbook file? (Excel 2010)
In 2013, it is very easy to copy data from one workbook to another and Paste As Link.
But how do I do link one table to the contents of a table in another workbook file? (Excel 2010)
SO If I understand you right, you just need to have some values from one workbook to be visible on another workbook, so If the Values from 1st workbook are changed the second workbook should update.
Is this right?
Cheers!
Deep Dave
Yes.
And if possible, when the table becomes larger on the source workbook, it dynamically becomes larger in the linked workbook.
Check this out - Probably this is what you want. I am not pretty sure if this works with the 2010 Version too.. -
http://office.microsoft.com/en-in/ex...103791160.aspx
It is very easy to understand. Let me know if you face any issues..
Else we will have to use VBA, or another option is to have Formulas dragged down till the maximum possible table length.
Hope it helps!
Deep
Last edited by NeedForExcel; 09-06-2014 at 03:46 AM.
Hello!
Can you show a examble? If I understand correctly your opinion, i am using add-in a-tools to link all workbook in excel.
At the same time, i can retrieve data in SQL, MYSQL, ORACLE, ACCESS to excel and do reports in excel by SQL language.
About excel online, add-in a-tools can help you to share excel in LAN or Internet, assigns permissions to all members in LAN.
Can you post a examble and i will do it?
I hope it will help you.
Thanks
Last edited by bluesoftsbl2; 09-06-2014 at 05:42 AM.
I can't post an example because I don't know how to do it.
I want Table2 in Book2 to be linked to Table1 in Book1, and show the contents of Table1. The Table size changes, so hopefully there is a way to make it dynamic.
I basically want Table2 to mirror Table1, but they're in seperate workbooks.
The instructions given by the link in post #4 do work in 2010.....just tested it.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
I didn't see that post! Excellent! Thanks! Will spread the Rep as soon as I can.
Thank You,
EnigmaMatter
Thank you for the rep.
EnigmaMatter: I sent to you link youtube. Please check the message status.
Thanks. I hope it is that you need.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks