Home > Software engineering >  How to use vb to extract excel column data
How to use vb to extract excel column data

Time:09-21

Such as excel - 1 A, B, C and D column data into excel - 2 E, C, L, M column

CodePudding user response:

Began keeping records in Excel macro, manual, complete the required function end record macros, press Alt + F11 key, check just record macro corresponding VBA code,

CodePudding user response:

The building Lord search under VB Excel, should be many, at least in c # under a lot of, you can reference,

CodePudding user response:

Are generally required for the implementation of the function of manual record macro, and then see the macro code, is basic, a see understand, the advantage of the basic language is with natural like English, and then you adjust the adjustment,

Such as above that you open the recording macros, page to the first sheet in the manual copy, then paste on the second sheet, the last stop recording macros, click edit, view the code, under basic adjustment adjustment,
  • Related