Filter by ref cell Value and copy to new sheet. Compile Error: Sub or Function not Defined

Greetings!

I am trying to modify this macro i found at the very informative website of Ron de Bruin.

It involves filtering the data and copying the filtered data to an existing worksheet.

The macro works on the spreadsheet i downloaded from Ron's site but for some reason it will not work on mine. It keeps saying "Compile Errror:Sub or Function not Defiined

Here's my code. I just edited the sheet name and cell value from the orginal to reflect my project sheet.

Please Login or Register  to view this content.

Basically, I have two sheets

One contains the data (Email Raw) and the other is the data dump (Email Ref)

My goal is to get the data from Email Raw to Email Ref based on the filtered value

I was able to solve the problem!

The problem was I am missing the Function code that makes this macro work. Add this code to a new module or below the macro itself

Please Login or Register  to view this content.