VB Script req plz - 2 .XLS files; remove duplicate account # found in second .XLS file.

[DoraExplorExcel]

Here is an easy one for the pros. Probably a quick VB Script?

I have uploaded the 2 following files.
bad_accounts.xls and MasterAccounts.xls
I am tasked with comparing 2 lists in Excel 2003. I need a simple 'search and destroy that line' operation.
Look up the first entry on the bad_accounts file (Column A). Cross reference this to the MasterAccounts list.
Once the account # is found in the (Column A) MasterAccounts list, it needs the entire row deleted from the MasterAccount list.

The bad_accounts list does not need to be altered. It serves only as reference for what needs to be removed from the master.
The only alteration I can make to the MasterAccounts list is that the duplicated Account# (from bad_accounts) can be deleted. It cant be altered beyond that because it gets run through a script right after it has been cleansed of the bad_account #s.

If I am not clear, I am sorry, ask questions if needed please.

As always, Thank you for your help. I would be lost with out my excelforum folks!

Additional and probably not-needed info.
Fact - None of these lines will be duplicated in their own sheet. They are all unique codes on their own sheet.
Fact - The account #s have different amount of characters per account # but they are also the only numbers that have 4 consecutive numerical characters or more.

Thank you

[protonLeah]

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.


This is a pretty big request in one chunk. I'm sure you'll get better response if you break down your question into several parts, so that they can be tackled one after the other.

Also, we're happy to help you with your effort, but nobody here will be keen on developing a solution from scratch. This forum is about helping people learn how to use Excel, not a free development service.

Have you started any work on this project yet?
How far did you get?
Where are you stuck?

We can help you develop your own code, but if you want someone to code this for you all the way, you should try and find a commercial developer.

[patel45]

protonLeah
are you sure your answer is appropriate for this post ? I think the title is good and the problem is very easy to solve, no need find a commercial developer.
95% of the users of this forum looking for the solution and not learn how to solve the problem

DoraExplorExcel
open the 2 files, copy sheet1 of Bad into Sheet2 od Master, rename the 2 sheets Master and Bad, then try this macro

Please Login or Register  to view this content.

[DoraExplorExcel]

Thank you Patel! I learn from these posts. Before I post, I research at least an hour trying to find something similar to my situation and not waste anyone's time. But unfortunately there is always something that makes my situation not like what I find. I have been a member here for years, and I save what I learn from these. I use them over and over again. Thank you so much for your assistance, and defending me from the nitpickers.