In Progress

Excel data field proofreader

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

Skills: Excel

See more: types sorts, types data entry fields, thank letter example, text proofreader, proof reading text, letter example, it field, example thank letter, example letter, duplicate data entry, data entry macro, be smith, a proofreader, quickbooks account, my j, jon n, smith, macro excel, jon, highlight, fix excel macro, excel duplicate, data upload excel, data entry quickbooks, create data

About the Employer:
( 2 reviews ) toronto, Canada

Project ID: #230472

Awarded to:

ashishyahoo

Dear Sir, I am ready for this. Kind Rgds, Ashish

$30 USD in 2 days
(1 Review)
1.6

14 freelancers are bidding on average $53 for this job

svet63

Hi. I think your previous project should've taken care of this issue. If your data persons select the names from a list and only type in the new accounts, then this issue is gone. On the other hand, deciding what's an More

$50 USD in 3 days
(56 Reviews)
6.5
kamosion

Please See PMB

$30 USD in 1 day
(3 Reviews)
3.4
hiratariq

Please See PM

$80 USD in 3 days
(2 Reviews)
2.4
mariap2103

Can start working with one for review

$100 USD in 7 days
(0 Reviews)
0.0
lyza0327

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

$30 USD in 7 days
(0 Reviews)
0.0
shaikh786

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....

$50 USD in 4 days
(0 Reviews)
0.0
kingbill

Sir, I could see your requirement in GAF.com. I 'm interested in the offer. I possess 13+ years experience in office works, especially in finance industry at different levels and had good skill in Data analyzing More

$30 USD in 2 days
(0 Reviews)
0.0
rightjyothi

More in my PMB, Please Check it

$75 USD in 5 days
(0 Reviews)
0.0
marccorn2005

Hi Peter, I am willing to take this job on I have alot of experience in this feild, please see PM for more details.

$30 USD in 1 day
(0 Reviews)
0.0
ranjanchabs

I am online and ready to take up your project.

$70 USD in 2 days
(0 Reviews)
0.0
madhuanz

Please Check My profile

$100 USD in 5 days
(0 Reviews)
0.0
MAULIK1710

i could help you out at the lowest price and best solution

$30 USD in 3 days
(0 Reviews)
0.0
ariful200008

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

$35 USD in 3 days
(0 Reviews)
0.0