存货 [英] Inventory

问题描述

我有两个包含相同库存商品编号的电子表格.假设电子表格A是商品编号和价格.电子表格B是商品编号和数量.如何设置自动将A中某商品的价格拉到B中的价格. 一个电子表格是由我们的会计系统生成的，而另一电子表格则由手工保存.  谢谢.杰克

I have two spreadsheets that contain the same Inventory Item #'s.  Let's say Spreadsheet A is item # and price.  And spreadsheet B is Item # and quantity.  How can I set up something to automatically pull the price of an Item in A into B.  One spreadsheet is generated by our accounting system and the other is kept by hand.   Thanks is advance.  Jack

推荐答案

杰克，

由于这个问题似乎与 无关SharePoint 2013开发人员，建议您将其发布到以下论坛，您将在此获得更多帮助和确认的答案.

As this question is seems not relate to  SharePoint 2013 dev, I suggest you post it to following Forum, you will get more help and confirmed answers from there.

https://social.msdn.microsoft.com/Forums/office /en-US/home?forum = exceldev

如果我误解了您的问题，请提供更多信息以供进一步研究.

If I misunderstand your question, please provide more information for further research.

最好的问候，

丹尼斯

这篇关于存货的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！