Now have two excel table, table A and table B
Form A line memory has several key (key word is A word of English, some of them are an English title) as shown in the following
The Muslim
Freedom
Tiananmen
The centre
Lippincott
Budapest Hotel
My Life on the Road
Seasonal Big Book Set
How to Write and illustrateenrollment a Scientific Paper
Point Made: How to Write Like the Nation 's Top Advocate

A number of column content form B
I often do some repetitive work, is to copy the form of A keyword to find some column of the table B
Want to ask an automated tool, can realize A keyword in the copy form B within A column in the table lookup, find automatically after selected contains keywords in the column of the line, can realize to delete, or remind

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:

Excel as ADODB database engine external database operations, using SQL query, SQL statements can also perform delete,

CodePudding user response:

If you don't want to use the program, you can use vlookup function

CodePudding user response:

QQ2776478814, this kind of want to be a tool 1, automatic search, B, two buttons: delete, ignored