Extracted from table 1 more column of table 2?
For example in table 1 have three columns province name phone number sex
Extracted from table 1 province name telephone number three columns as the second column of table ii, the third column, the fourth column, will represent for the province province a merger with name: the name as the first column of table 2
Can you use VBA to realize?

CodePudding user response:

Operation, you said with the mouse keyboard again, recording macros, then open the macro editor, code is lying there, and then make a little change

CodePudding user response:

It is as you say the word or excel?

CodePudding user response:

What would the VBA,
Sheet2 completes the header, writing formula on the second line:
A2 formula=B2 & amp;" : "& amp; C2
B2 cell number input=later, the mouse directly cut to sheet1, select the second row province data, enter
The operation and B2, C2 and D2
Bullish sheet1 has several lines, select A2 - C2 three cells, pull down the corresponding number of lines,

CodePudding user response:

Of course can use VBA to realize,