Remove an account range form a column with account numbers.

Hi All,

I am not sure if this is possible i was thinking maybe it would need to be a find/remove macro or a filter remove.

In column A there is about 6000 accounts (No Duplicates). Below is a sample of accounts and i want to remove all account that start with 997 or not move then to the new sheet.

1234567890
2345678910
3456789012
4567890123
9970000001
9971234567
9972223457

I already have a macro that moves the data but i want to eith filter out the 997 accounts of delete them once i have moved the data to a new sheet.

Here is the macro i am using so far that i want to enhance:

Please Login or Register  to view this content.

I am not a great code writer so forgive me...

Use this line

Please Login or Register  to view this content.

Hi AB33,

That did not work it filtered out all accounts. Not sure if that is due to the other filter i have, but i dont see how that would effect it:

Please Login or Register  to view this content.

Just tested it with out the other one and still same result it filters out all accounts.

Please attach the sample, so we can easily see what is going.

Here you go

Sorry!
It was my mistake,
should be

Please Login or Register  to view this content.

No worries AB33...

Do you see anything else that i could do better? I am just a hacker a use others code to make my macros and they do work but are maybe not the best way of doing things.....

I will be offset of the site and will be back in the evening. I will have a look. I have got your data, just need explanation what are trying to do and will come up with a solution.

Sorry still does not filter out the 997 accounts...

I hope you see this... as i still can't get it to work

Any chance someone else can help me out with this one?

I have tried to search for anything on this tyoe of filter and not having any luck.

So my guess is that the no reponse means that this might not be possible thru code? really dont want to add a column and do the =left....

Never mind if figured another way of doing this.... TY

I have not forgotten or ignored you. I was off site for the last 3 days.

LOL AB33

I can to the same solution you did.... filter for all account less then 9970000000....