hobbiton73
02-03-2013, 07:14 AM
Hi, I wonder whether someone may be able to help me please.
I'm using the attached file to record staff resource, but I have a problem when copying and pasting data into the sheet as opposed to manually entering the information.
If you enter your name in column "B", you'll see that there are a number of columns which are now populated by pre-defined text.
However, the problem I have is that when I copy and paste the names into column "B", these columns are no longer populated with this text.
I'm not particularly well versed in VBA, and depsite trawling through a number of tutorials, I've been unable to find a solution whereby the VBA text populates the cells, both when information is manually entered into the sheet and through copy and paste.
I just wondered whether someone may be able to take a look at this please and let me know where I'm going wrong.
Many thanks and kind regards
Chris
I'm using the attached file to record staff resource, but I have a problem when copying and pasting data into the sheet as opposed to manually entering the information.
If you enter your name in column "B", you'll see that there are a number of columns which are now populated by pre-defined text.
However, the problem I have is that when I copy and paste the names into column "B", these columns are no longer populated with this text.
I'm not particularly well versed in VBA, and depsite trawling through a number of tutorials, I've been unable to find a solution whereby the VBA text populates the cells, both when information is manually entered into the sheet and through copy and paste.
I just wondered whether someone may be able to take a look at this please and let me know where I'm going wrong.
Many thanks and kind regards
Chris