Blackie50
09-14-2011, 07:31 AM
Hi there
Wonder if anyone can help with following. Its very much related to the earlier query regarding unique account numbers.
Anyway I have a word document that has 16732 pages with summaries, totals, paragraphs, underlining etc. A number of pages have an account number on a line with customer details below.
I have imported this in to excel and got the account numbers in column A. Thing is there are now 200,000+ rows with a lot of other rubbish thats been brought over from Word.
I would like to get rid of all this without having to delete manually.
Can anyone help with macro to delete the row if col A isn't like/in the following account format - NNNNNNNLN (N = number, L = letter) - not bothered about customer details just need to capture the account numbers and then apply the formula/macro supplied in earlier thread to come up with the actual customer count.
thanks for any help
Jon
Wonder if anyone can help with following. Its very much related to the earlier query regarding unique account numbers.
Anyway I have a word document that has 16732 pages with summaries, totals, paragraphs, underlining etc. A number of pages have an account number on a line with customer details below.
I have imported this in to excel and got the account numbers in column A. Thing is there are now 200,000+ rows with a lot of other rubbish thats been brought over from Word.
I would like to get rid of all this without having to delete manually.
Can anyone help with macro to delete the row if col A isn't like/in the following account format - NNNNNNNLN (N = number, L = letter) - not bothered about customer details just need to capture the account numbers and then apply the formula/macro supplied in earlier thread to come up with the actual customer count.
thanks for any help
Jon