Excel data field proofreader
$30-250 USD
Pago na entrega
I have spreadsheets with fields containing various text fields which I upload into quickbooks. The problem is any typo or erroneous extra "space" (Non-breaking-space) will create an undesirable duplicate entry... for instance if I have an account "John Smith" and my data person types it as "Jon Smith" or as "John Smith" (note the extra spaces) I have a duplicate account causing all sorts of confusion.
What I need is something like a macro that will
A)Highlight the error (Can't fix it if I can't see it, and I hate proof reading a 1000 or so entries!!)
B)If at all possible if I mouse over or click on the highlighted field that has the error, could a drop down box be populated of potential correct selections.
From my above example, I click on the box and all the potential items starting with the letter "J" come up
I thank you coding gods for your assitance!
Peter
ID do Projeto: #230472
Sobre o projeto
Concedido a:
14 freelancers estão ofertando em média $53 nesse trabalho
Hi, Peter. I think I can help you with this. Kindly provide more info and if at all possible, a sample file so I could have a look at it. Thanks. Lyza
Dear, I can provide you more convience than you have ever wanted. Just give me some sample file and see how i can do thing beyond imaginations....
Hi Peter, I am willing to take this job on I have alot of experience in this feild, please see PM for more details.
Sir, I 'm very interested in the offer. I have 6+ years experience in ms Execl, I look forward to hear from you and thank you for your consideration. Afiful Alam