Deleting rows that don't contain mobile numbers from a list

Hi guys,

We have a spreadsheet that we get every three months that contains a compnies mobile phone usage. We need to pull from that spreadsheet every personal call made by certain users.

We have a list of the personal numbers that they occasionally call, we want to set up a Macro to scan the spreadsheet for those numbers and delete everything else. This will leave only those numbers from which we can work out how much each user is to be recharged. This quarters spreadsheet is around 60,000 lines long.



The numbers we are checking are in column G. Some users only have a few personal numbers where as others have around 30 that will need to be checked for.




It is a tedious process to do manually

Any help would be appreciated.

Thanks Billy