Hi all,

I have a accounting flat file that I open in Excel. It lists a file number and a GL code. Based on the start of the file number and its existing GL code, I need to change the GL code.

Example

A B C D E F G H
I139708 11/15/06 ST-53017882 12002 GLOBISCL 46.49 6040-3-5 JMFILE
I139728 11/16/06 ST-51017809 12003 ACLSHIPP 236.16 6050-2-4 JMFILE
I139728 11/16/06 BT-54016873 12002 GLOBISCL 136.29 6050-2-4 JMFILE

I need to have a forumula or macro that will search each line and compare against multiple options
If ST-51 and 6050-2-4 , then change 6050-2-4 to 6050-7-4
If ST-53 and 6040-3-5 , then change 6040-3-5 to 6040-7-5

I have about 25 conditions to check on each line. If match change GL code to new GL code. If not match, leave alone and check the next row. This task occurs every week day.

Any Help Appreciated.
Rgds
John