VBA code to remove rows on Select...

[GUIDO22]

I receive a CSV file from a service that provide horse racing data. I wish to work through the rows and using a simple cell value of say 0 to distinguish rows I want to avoid from those I want to keep.

When I have worked through all the rows - I wish to be able to invoke a VBA function, to physically remove all rows from the worksheet where the cell value =0.

Does anyone know the code to iterate through 1...n rows in a worksheet and depending upon a specific cell value in each row delete that row from the worksheet and continue down until all rows have been processed please...?

This would make things much simpler for me on a day to day basis....!

Thank you.

 

[bob fitz]

Use the wizard to create a "Delete" query.

 

[GUIDO22]

Use the wizard to create a "Delete" query.

Thanks Bob - I am using Excel 2007, where is this Wizard feature you mention?

And will I be able to create a macro that I can run with every spreadsheet I create...?

 

[bob fitz]

Ooopps....
Sorry. I was thinking that this was an Acces question.