Name Inputs - Please help!!

[ashie]

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

[Aladin Akyurek]

On 2002-04-15 09:00, ashie wrote:
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

You could perhaps use the AutoCorrect feature.

[ This Message was edited by: Aladin Akyurek on 2002-04-15 09:11 ]

[Brian from Maui]

Go to Tools/Auto Correct
then make your list

Oops didn't see your post Aladin!

[ This Message was edited by: Brian from Maui on 2002-04-15 09:08 ]

[Asala42]

Hey,

Have you considered using Data Validation? That would require a list (to be updated) of your 40 or so core entries - but would effectively prevent errors on data entry.

Hope that helps.
Adam

[Parra]

I experienced the same thing and Data Validation worked great, the only thing is you have to create a list of suppliers, and if you get a new one, you have to update your list. But it works great

[Aladin Akyurek]

On 2002-04-15 09:06, Parra wrote:
I experienced the same thing and Data Validation worked great, the only thing is you have to create a list of suppliers, and if you get a new one, you have to update your list. But it works great

You can create a dynamic name range to circumvent that.

I didn't suggest data validation for the reason that it has to be set up in many rows. AutoCorrect seems to me cheaper and much nicer for an experienced data-entry person.