gorilla Posted June 23, 2017 Report Share Posted June 23, 2017 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 v184.108.40.206 Quote Link to comment Share on other sites More sharing options...
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.