We need a macro developed which will eliminate duplicate & unwanted records from an Excel file

Here are some of the requirements for this project:

- we want to eliminate all records where Creditor field is blank

- we want to delete records from the "Filing" column which include any

of theses terms: Release, Vacated, Satisfied. However, we need to

delete ALL the records associated with that judgment. The sample

data sent yesterday had some of those examples highlighted.

- when getting rid of duplicate records, we need to key off of more

than just the name, as the name can sometimes be slightly different

even on related records. Perhaps we can also key off "Judgment

Amount" and/or "File Date" to make the connections.

- we need ability to manually input a list of Creditor Names that we

want removed from the list

-- this will change from state to state, but it would be good if we

could develop this so that we can save a list from a specific

state to be used anytime we may run records from that state

Please ask any additional question you have to help you understand the scope of this project

Skills: Excel, Visual Basic

See more: ask excel, theses, save to excel, excel duplicate, delete duplicate, amp visual basic, excel macro develop, sample visual basic excel, excel additional, project macro, eliminate, visual basic amp, may need change, duplicate file, unwanted, excel amp macro, delete specific data macro excel, excel macro save, save file name, will understand different, question excel, excel macro data list, need macro excel, excel delete, visual basic delete records

About the Employer:
( 4 reviews ) Mesa, United States

Project ID: #2561215

Awarded to:


As discussed

$80 USD in 3 days
(41 Reviews)