Auto insert value in a column

Hi there Everyone! I have the following problem. I have an excel sheet where I gather information about companies. There are two columns involved in my problem. Column "D" and column "E". In column "D" I put the country code (example: DE for Germany, GB for England and so on..) In column "E" I put a number (for example: 45786521). What I would like Excel to do is to autoinsert the value of the column "D" before the numbers I have written in column "E". For example if in Row 12 column "D" is GB. And then I write the number 555888777 in column "E", then after the number is written and I hit Enter I would like column "E" to look this way: GB555888777. So the GB (value of the column "D") is inserted at the beginnig of the number I just wrote in column "E". How can that be done?

P.S.:I know that there is a possibility to add the values of these two columns in another column, but as there are far too many columns in the worksheet I would not like to add an extra column just for this.

Thank you in advance for your help, and have a nice weekend!

This can be done with VBA(macro)

Place this code in the worksheet module,
Go to this link to find out where that is:http://www.contextures.com/xlvba01.html#Worksheet

Copy and paste this code there

Please Login or Register  to view this content.

When you change a value in column E, the vba code kicks in

hunsnowboarder,

If you're problem is solved then please mark it as solved

VBA Noob