英文:
How can I automatically copy data from one Excel sheet to another and have it sort into specific cells?
问题
如何将数据从一个Excel电子表格复制到另一个电子表格，以使复制的数据自动排序到特定的单元格中
我想将数据从一个电子表格复制到另一个电子表格，它们具有相同的单元格列。如何将这些数据复制，以使其自动放置在正确的单元格编号中，而无需手动操作？
尝试了各种排序方法，但无法使其工作。
英文:
How to copy data from one excel spreadsheet to another where the copied data gets automatically sorted into specific cells
Im looking to copy data from one spread sheet into another which has the same cell column. How can i copy this data so that it automatically gets placed into the correct cell number without doing it manually?
Tried all sorts of sorting methods but cant get it to work
答案1
得分: 1
看一下XLOOKUP：
=XLOOKUP(A3,Sheet2!A:A,Sheet2!B:B,"",0,1)
英文:
Have a look at XLOOKUP:
=XLOOKUP(A3,Sheet2!A:A,Sheet2!B:B,"",0,1)
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论