Jump to content
Macro Express Forums

Search the Community

Showing results for tags '%t1% = %t2%'.



More search options

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


Forums

  • News and Information
    • Guidelines for all Forums
  • Community Forums
    • Macro Express Pro
    • Macro Express 3.x
    • Macro Express 3.x Third Party Tools
  • Private Forums
  • Forum Archives

Find results in...

Find results that contain...


Date Created

  • Start

    End


Last Updated

  • Start

    End


Filter by number of...

Joined

  • Start

    End


Group


AIM


MSN


Website URL


ICQ


Yahoo


Jabber


Skype


Location


Interests

Found 1 result

  1. 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
×