Hello,
I'm here to ask help to make a Macro script what I'm struggling.
Here's my situation.
I have a Excel sheet like this and "A column" is important. Each row of "A column" contains a text string(XXXX-XXXX) and the total number of rows is 600.
A column B col C col D col E col
1000-1500 text1 text2 number1 number2
1000-1501 text1 text2 number1 number2
~
1000-1599 text1 text2 number1 number2
1000-1800 text1 text2 number1 number2
1000-1801 text1 text2 number1 number2
~
1000-1899 text1 text2 number1 number2
1000-3500 text1 text2 number1 number2
~
1000-3699 text1 text2 number1 number2
2000-5400 text1 text2 number1 number2
~
2000-5599 text1 text2 number1 number2
And I have a text file "list-a.txt" which consists of roughly 300 lines and each line has a text string(XXXX-XXXX).
1000-1504
1000-1507
1000-1810
2000-5411
2000-5599
What I need is to delete data in column (B:E) of a row in Excel if the text sting XXXX-XXXX is NOT in "list-a.txt".
And I need to type/input data in column (B:E) if the text string XXXX-XXXX is IN "list-a.txt".
For example,
if "list-a.txt" file has only 5 lines as above.
The Excel sheet has to be the same as the following.
A column B col C col D col E col
1000-1500
1000-1501
1000-1502
1000-1503
1000-1504 newT1 newT2 newN1 newN2
1000-1505
1000-1507 newT1 newT2 newN1 newN2
1000-1508
~
2000-5410
2000-5411 newT1 newT2 newN1 newN2
~
2000-5598
2000-5599 newT1 newT2 newN1 newN2
I used "Text File Begin Process" command from file "list-a.txt" and Set Variable to %T1%. And tried with many more combinations like "Repeat Until" command but all failed.
Please help me out.
* Windows 7 and Macro Express v3.10.2.1