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

No problem, are we assuming that all the mobile numbers start 07?

Or are they entered as numbers so start 7?

On the assumption that they all start 7, the below will copy all mobiles to sheet 2

Please Login or Register  to view this content.

Thanks Kyle,

Though thats not quite what I'm after though.

For example say we have

077825754546
0746464646464
0774646464877
076694797979

and 0774646464877 and 0746464646464 are on the users personal call list than we need everything else ie(the rows containing 076694797979 and 077825754546) removed. So we can then add up the values of the personal calls.

Thanks

Ah gotcha

The easiest thing to do is autofilter the sheet, in the dropdown for the phone number field select custom - then in the first dropdown select "does not begin with" and type 07.

This will filter out all mobile calls

I've only got Excel 03 so the process might be a bit different - if you can't figure it out, hopefully someone with 07 can help you