Thanks for the reply Rahul....I just wasn't clear enough on my post. The data I provided is just an example, and is actually dynamic relative to the values in columns 4, 5, and 6. Basically, once I've got the data from columns the "key" column and columns 1, 2, and 3, I need to make MANUAL entries into columns 4, 5, and 6. This is just the way it has to be....there's no way that this can be set automatically because in my actual situation, I need to consider each entry case by case...it would be absolutely impossible to do this with code.

The idea is for me to only conduct the analysis once on the record, make my manual entries as needed, and then have those manual entries held when other updates are made to the other fields within the record.

I hope this makes some sense...

Thanks