Excel VBA创建列并根据另一列填充数据 [英] Excel VBA create columns and populate with data based on another column

问题描述

好的，所以如果另一列的值匹配，我必须创建两个新列，并用另一个工作表中的数据填充它.我将其分解以使其更易于理解.有两个工作表:"JULY15Release_Dev状态"和"JULY '15 Rel".这两个工作表的标题A列的标题均为"eRequest ID".我需要为"JULY15Release_Dev status"创建两个新列，并使用"JULY '15 Rel"中的数据填充该字段(如果"eRequest ID"与该特定字段匹配)数据行.

Okay so I have to create two new columns and populate it with data from another worksheet if the values for another column matches. I'll break it up to make it easier to understand. There are two worksheets namely; "JULY15Release_Dev status" and "JULY '15 Rel". Both of these worksheets have a header of "eRequest ID" for column A. I need to create two new columns for "JULY15Release_Dev status" and populate it with data from "JULY '15 Rel" if the "eRequest ID" matches for that specific row of data.

通过创建两个新列并向其中填充数据，不一定必须先创建然后填充"，复制精确的2列也可以，只要保留数据即可完好无损的.如果数据受到任何影响，将采用日期/时间格式.预先感谢您的帮助，因为我是这个方面的初学者！

By creating two new columns and populating it with data, it doesn't necessarily have to be "creating then populating", copying that exact 2 columns is also fine, so long as the data remain intact. The data will be in date/time format if it affects anything. Thanks in advance for any help as I'm a total beginner at this!

推荐答案

替代图的方法

=INDEX(Sheet!A:1:1048576, MATCH(A2, 'JULY ''15 Rel'$A:$A,0),[column number])

无需数据排序如果要将其放入宏中，除非基于其他变量或任务使用，否则它有点多余.

no data sort necessary if you want to put it into a macro it is a bit redundant unless used based on other variables or tasks.

这篇关于Excel VBA创建列并根据另一列填充数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！