Hi.
I have two worksheets. The first is a bit messy due to user error when inputting. It looks something like this
Line Description
001 Bananas
001 Bananass
001 Baaannaaas
002 Cheese
003 Green things.
I need to correct these descriptions with the second worksheet data which has the accurate description for all lines, for example:
Line Description
001 Bananas
002 Blue Cheese
003 Lettuce
To manually correct all of the first sheet would be a tedious task as there are a good 18-19 thousand rows of data.
I should mention the first sheet is a 97-03 spread sheet and the second is a 07 excel spread sheet (as the second as over 100 thousand rows of data)
How can I do this?
Bookmarks