Home > Software engineering >  VBA to find and copy the same data
VBA to find and copy the same data

Time:09-26

In front of the great god to find a set of data, in fact, more than one group, to find out all,
Want to achieve after the K2 input digital automatic dividing K2 to S2/AD2/AL2, such as 12738 according to the former is decomposed into 127273738 after click area with a key, N lookup columns B column and K2 and copy the same data, and to find the same number at the back of the three data replication in the OPQ corresponding position

Similarly V for the S2 in E column of the same data, and then behind WXY copy corresponding three data,
AD column is looking for in the G column with the same data and in the AE AA2, AF, AG to display the AD data to find behind three data
AL column is looking for in I column with the same data and in AM AI2, the AN, AO to show behind the AL data to find three data

  •  Tags:  
  • VBA
  • Related