VBA Concatenate Solution needed

[Dean England]

Hello all,

I have a small problem and I'm looking for a VBA solution. I have a form that we frequently use and I use concatenate in several areas. If we enter a code in the selection field the required target fields are populated with the appropriate names, vesting, etc.

In one area, there are several cells in which we occassionally need to add information, which is not in the lookup locations because it is a one time occurance and this, of course, erases the formulae in those fields. After the form is printed the formulae have to be replaced prior to closing the form.

I'm looking for a solution where, either the appropriate code can be entered in the selection field to update the target field or the information can be entered directly into the target field. I have attached a small example to give an idea of what I need. I hope it's makes more sense than this explanation, because I think I just confused myself.

Thanks for looking,

Dean