I have one huge database where someone has to input invoice info - we have about 40 core suppliers who invoice us numerous times a month.
The person who inputs the data makes spelling mistakes which makes it hard to report on the data i.e. Carat becomes Carrot, Carratt etc.
Is there any way of the spreadsheet telling when for instance Car is put in that it recognises the letters and inputs Carat International?
Please help as I might as well input the data myself rather than trawl through the spelling mistakes!
Thankyou!!
Ashie UK
The person who inputs the data makes spelling mistakes which makes it hard to report on the data i.e. Carat becomes Carrot, Carratt etc.
Is there any way of the spreadsheet telling when for instance Car is put in that it recognises the letters and inputs Carat International?
Please help as I might as well input the data myself rather than trawl through the spelling mistakes!
Thankyou!!
Ashie UK