I have a data file which I recieve regularly which needs to be cleane
up before I use it. The data looks like this

Item Description
123, Widget
124, Bodgit
125, Scarper
123, Unknown
124, Unknown
125, Unknown

Does anyone have a routine which could go through the above data an
make sure that the second field is corrected to what the descriptio
should be ?

I.e.

If first cell value equals 123, then make second cell value = widget
Or
If first cell value equals 124, then make second cell value = bodgit
Or
If first cell value equals 125, then make second cell value = scarper

The idea being that for every example of unclean data I come across,
would copy an extra line of code which deals with it in future edition
of the data file that comes in.

Hope someone can help ?

Thanks


Terr

--
Message posted from http://www.ExcelForum.com