Okay, I used the sheet that I had sent you and it works but just for the first two schs/columns. The example I sent you only had two schs/columns but the work book that I work with can have many that need to be converted. This macro did fees for the two columns over but not for any of the other columsn on the sheet. So on the after sheet i column b only two schs listed in column c has fees listed in column b. It did not pull the fees for all the other columns.