Use VBA, but wants to realize automation, thank you

CodePudding user response:

All the first row, then menu - data - screening of the funnel prick, in the corresponding column to select or enter your search string,
.

CodePudding user response:

Do you want to use vb to realize? Or in the excel vba to realize? Vb realize reference excel that, excel in, edit the macro, the module with a loop and the contents of the TXT text to the comparison, vba statement and vb basic about the same, are you sure you can achieve, sheet1. Cell to access excel content of cells, you try it on

CodePudding user response:

The original poster hello, actually achieve this without VBA, as long as use pivot table, will solve the problem easily