两个工作簿之间的镜子工作表
我要实现的目的是如下，我有“ Workbook A”和“ Workbook B”，在工作簿B中，有一个工作表“ SheetB2”，我希望将其包括在工作簿A中。但是，对SheetB2所做的任何更改在工作簿中，AI希望将其复制到工作簿B中的相应工作表，反之亦然。
在使用内置工具或VBA的excel中，这是否可以？
人们可以将我指向使它成为可能所需要的工具或VBA脚本的方向吗？我想可以有很多步骤来解决合适的解决方案。
What I am trying to achieve is as follows, I have "Workbook A" and "Workbook B", within Workbook B there is a worksheet "SheetB2" which I would like to be included in Workbook A. However, any changes made to SheetB2 in Workbook A I would like to be replicated to the corresponding worksheet in Workbook B and vice versa.
Is this possible within excel utilizing built in tools or VBA?
Could people point me in the direction of the tools or VBA scripting that would be required to make this possible? I'd imagine there will be a number of steps to a suitable solution.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论