Data filter and deleting rows in visual basic
 

Hello,
In my excel file I would like to filter collumn C,D and G for particular
criteria by using a macro code in visual basic. This macro code should also
delete the rows that did not pass the filter. This can't be done with the
autofilter function, because I would like to use the filtered data for
making a pivottable and graphs (by using autofilter function all data is used
for making a pivottable+graphs, also the data that did not pass the filter).
So I need a code that filters the data for row C,D and G (each has another
criteria) for a specific criteria, and also deletes the rows that did not
pass the filter. It would be great if someone could help me!