问题描述
我有两个Excel电子表格。在第一个电子表格中，我有近20列，第一列是唯一ID。再一次，Spreadsheet 2有自己的大约20列的数据，但这两个speardsheets之间只有4列匹配，包括类似的唯一ID列。
我想要实现的目标：
将电子表格2的电子表格中的列与电子表格1相比较。
表示存在电子表格2中的一个常见列中的电子表格1中的更新然后它应该更新差异，然后在比较后突出显示它。
为了解释自己更多，Say Spreadsheet 2，有4个条目，如111,222,333,444并且假设我想验证条目111的值。然后我的公式应该在电子表格1列A中搜索111，然后它应该为它选择数据或值，然后将其与电子表格2条目的值或数据进行比较。 111，然后让我知道在比较之后是否有任何更新或更改在任何公共列中。
可以vloo kup函数执行此操作或者可以为此建议一些替代方案.. ???
我可以通过Spreadsheet1上的命令行按钮执行此操作（只需单击按钮它应执行上述任务比较）。
我尝试了什么：
我试过各种VBA代码但最终它们要么比较单元格范围，要么添加/删除新的行和列。所以我想重新开始并询问是否有人可以帮助我。我认为我必须在某处解决这个问题，因为这是每个人每月/每季度从不同报告中手动更新记录的基本问题。希望你理解。
I have two Excel spreadsheets. In the first spreadsheet I have nearly 20 columns and first column is unique ID. Once again Spreadsheet 2 has its own data of about 20 columns but only 4columns matches between this two speardsheets including similar unique ID column.
What I want to achieve:
Compare the column's that are similar in both the spreadsheet of Spreadsheet 2 against Spreadsheet 1.
say there is an update in spreadsheet1 in one of the common columns which is present in spreadsheet2 then it should update the difference and then highlight it after comparison.
To explain myself more, Say Spreadsheet 2, has 4 entries like 111,222,333,444 and suppose I want to validate the value for entry 111. Then my formula should search for 111 in Spreadsheet 1 Column A, then it should pick the data or value for it, then compare it with the value or data of the Spreadsheet 2 entry for 111, and then let me know if there is any update or changes made in any of the common columns after comparing.
can a vlookup function do this or can someone suggest some alternative for this..???
and can i perform this action through command line button on Spreadsheet1 (just by clicking the button it should perform the above task of comparison).
What I have tried:
I tried various VBA codes but in the end they either compare the cells range or add/delete new rows and columns. so I thought of starting it afresh and asking if someone can help me. I think there must me a solution for this problem somewhere as it's a basic problem with everyone who updates there records manually from different reports monthly/quarterly. Hope you understand.
这篇关于将从Excel工作表2获取的数据更新为excelsheet 1的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！