• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 325
  • Last Modified:

vbScript in Excel - Search Excel sheet and delete undesired lines...

Hi!

I am going over a very big excel file, and I want to summerise subjects.



I want to go over a specific column of the the whole sheet, and delete all lines which do not include a specific string (say "Brg").
How can I do it ?
I want to go over a specific column of the the whole sheet, and delete all lines which do not include one of X strings.
Example :  I want to delete all lines which do not include one of the following strings : {"Str_1", "Str_2", "String3", "Str4"}.
How can I do it ?
I want to go over a specific column of the the whole sheet, and delete all lines which do not include one of X strings (but do not delete lines which the cell is Empty).
Example :  I am going over column J, and I want to delete all lines which do not include one of the following strings : {"Str_1", "Str_2", "String3", "Str4"}, BUT I do not want to delete lines in which the "J cell" is empty.
How can I do it ?



After I delete all "undesired lines" I want to summerize Column K and Column M.
How can I do this ?


I am working with Office 2007

Thanks
zmau
0
zmau
Asked:
zmau
  • 2
2 Solutions
 
Saqib Husain, SyedEngineerCommented:
Have you tried

Data > Filter
0
 
zmauAuthor Commented:
I have no idea what does it mean......
Sorry
zmau
0
 
Saqib Husain, SyedEngineerCommented:
Select the data

From the excel ribbon select the "Data" tab

From the ribbon items select "Filter"

Then click on the dropdown at the top of your desired column and select an option from "Text filters"

Come back if you still have problems
0

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now