Good morning to all,
I am looking for some help. I have most of the VB codes in my workbook but some I cannot figure out right now.

I have attached my test workbook. Test01, Test02, Test03 has colour. This is to identify each project. I have made 3 for the three options in column Q. The beige color is the end result that I need.

“amd” option:
If a user select “amd” from the list in “Q” then copy what is in the Column M (Target.row) and add it to column R (Target.row) but add a “/001” at the end.

If you look at Test01 then after selecting “amd” from Column Q, Column R will become Test01/001/HS/001.

“Term” option:
If a user select “term” from the list in “Q” then 3 options are available based on the msgbox:

Yes: copy what is in the Column M (Target.row) and add it to column R (Target.row) but add a “/T01” at the end. Then add a new row (bellow), copy the information above from Column A to K and add it on the new row. Search (this is the tuff part) what is in the above row in Column M then change the 001 to 002 on the next added row. Therefore, putting the Test01/001/HS to Test01/002/HS.

No: copy what is in the Column M (Target.row) and add it to column R (Target.row) but add a “/T01” at the end. (Test01/001/HS/T01)

“option” option:
Add a new row (bellow), copy the information above from Column A to M and add it on the new row. Copy what is in the Column M (Target.row) and add it to column R (Target.row) but add a “/001” at the end.

It is mostly the “term” option that I am having problem with. The rest I have most of the code. This dummy workbook is for something larger that I have created.

If you need the original Workbook, I will be glad to add the full codes and explanations.

If someone could help me to tweek the codes I would be grateful.

Thank you all.
http://www.thecodecage.com/forumz/mi...post1055004277

Book1.xlsm