Help deleting populated cells when starting new search

Hi guys

After having some excellent help from you guys i need to complete this code to work just how i need.

I have attached the sample file where i introduce a ref. number and select a name in the drop box and then the code apply a autofilter to search for those data and puts it in "N10" and "O10". Then i have a button that separates that data by periods of time starting in "R2".

What i need is to when i introduce again a new ref. number for a new search that the values that were separated in periods be deleted, so then it can be populated with the values of the new search.

Thanks in advance.

Sample Test.xls

Title changed

Hi bazofio,

Try this:

Please Login or Register  to view this content.

Hi Bazofio,

Thanks for the rep - the amount of records over there shouldn't matter - and you're welcome!