How to Construct Auto Boolean Strings using VBA

[satish78]

Hi Friends,

I tried looking mrexcel posts and google sources for query to find VBA answer.
Here what I am looking for is:

Sheet1 ColumnA has data of boolean strings like attached in the document.
The row numbers varies every time whenever I change the data.
Boolean example has shown in image attached.

I need a VBA to do the job.
Let me know if you have questions.

Hightail Spaces

Hightail Spaces lets you send unlimited files, of any size, to anyone. Collaborate with your team and evolve your work.

spaces.hightail.com

 

[satish78]

I am sorry but I'm still not able to understand ! Perhaps you can give more details of how jvm becomes A and B and C and D and NOT E and NOT F or maybe some other forum members could understand something that I am missing

Here is an example, I just took 6 rows only.

Java AND python AND J2ee AND JSP AND JDBC AND JVM
Java AND python AND J2ee AND JSP AND JDBC AND NOT JVM
Java AND python AND J2ee AND NOT JSP AND NOT JDBC AND JVM
Java AND python AND J2ee AND NOT JSP AND JDBC AND JVM
Java AND python AND J2ee AND NOT JSP AND NOT JDBC AND JVM
Java AND python AND J2ee AND JSP AND NOT JDBC AND NOT JVM
Java AND python AND J2ee AND NOT JSP AND NOT JDBC AND NOT JVM

As I mentioned in my post, that, rows gets change when I replace/add new data. So, after JVM, there are other keywords in rows.