VBA: deleting rows returned blank by a function

[MaryBrenna]

Hello everyone,

is there any possible way to set up a macro that will delete rows that were returned as blank from a function? I am putting together a book database and I want to have separate sheets for languages, genres etc. I decided to create a "General" sheet for all the info and then use links so that I only need to put the new information once.

To show only the selected books on a sheet, I used the if function as follows, so the name of the book only appears if it's in English. (And I have used this one for columns A-F to display all the info about the book as well.)
=IF(General!$D2="English";General!A2;"")

Now how could I automatically delete the rows which are returned blank by this function? I have tried a macro for deleting blank rows, but since these are not truly empty, it did not work. Or should I put the if function in a different way first?

Thank you all for your answers

---

Using Excel 2010 on Win7

 

[MaryBrenna]

Sure it did, it's just that so far I haven't got that much data in the workbook as to notice the speed difference. You know, I wanted to make it work first. So I actually tried all the options you guys gave me. But thank you for pointing that out, I'm sure the list is going to be a long one