VBA - If statement and small piece of code

Hi,

I am trying to automate a piece of work that I do a couple of times a week but I am new to VB so could really do with some help!

Basically this is what I need to do:
1. Copy data (number) from Col B to Col A but only if there is data present in Col E
2. With the new data in Col A, change the second digit to an "x"
3. If there is no data in Col E nothing needs to be done.

I assume I will need to firstly do an if statement which in turn will carry out a copy command. After that it would just require code to change the second digit?

Hi, thanks for the quick reply. I have attached a work book, basically the first page is the output that I would like, the second is the original that I receive. This is just a small sample of what I need, hope it helps.

Just tried your code and it certainly does most of what I want to do. The only thing is that if there is no data in Col E I do not want it to copy from Col B to Col A. I also need to try to make the second digit in Col A an "x"

Originally Posted by conorcleary

Hi,

I am trying to automate a piece of work that I do a couple of times a week but I am new to VB so could really do with some help!

Basically this is what I need to do:
1. Copy data (number) from Col B to Col A but only if there is data present in Col E
2. With the new data in Col A, change the second digit to an "x"
3. If there is no data in Col E nothing needs to be done.

I assume I will need to firstly do an if statement which in turn will carry out a copy command. After that it would just require code to change the second digit?

Maybe this modification to kbkumar's code can help with Point 2.

Please Login or Register  to view this content.

Thanks John, that worked a treat. Now the only issue is that I need to put in the exception that if there is no text in Col E do not copy from Col B to Col A

Thanks so much guys, works perfectly! Youve just saved me 5 hours per week!

conorcleary and kbkumar, you are both welcome. Glad I could help out. Seems conorcleary has a working solution glad to hear that.