Nov 18 2018 05:31 PM
I am trying to automate a particular function in Ms Excel 2013 (and later). The details are as follows:
If a particular field has a particular string, I would like the entire row to be deleted.
The field has custom string (text) so its able to accept everything, however, if a certain string appears, lets assume the string is "he did it". if that appears as part of the string in that one field, action should delete the entire row.
The question is, what is the best approach to implement that. Is it using VBA (or Macros) or could this be done without VBA.
In addition, could the same be done using an app done in C#, if so, how??
Nov 18 2018 08:22 PM
Nov 19 2018 01:05 PM
Nov 19 2018 02:40 PM
Nov 19 2018 03:37 PM
pls see attach file.
hope you can make something out of it.
thanks..