Change/replace vb code .EntireRow.Insert (2007)

Good evening,
I would need help replacing a code I have. The code is doing the following:
Every time I add a number in column B the code runs the following:
Copy what is in column A and adds it to column C but also copies it to how many rows was inserted in Column B. Therefore if 002 is added to column B then it will insert the numbers of row then add the number:

Ex:
If:
Column A = Test
Column B = 002

Then
Column C = Test/001/HS

Then
Column A (next row) = Test
Column B (next row) = 002
Column C (next row) = Test/002/HS

Here is the code:

Please Login or Register  to view this content.

The code is “.EntireRow.Insert” but I just need it to be added but not as a “.EntireRow.Insert”.
Could someone help me with the changes?

Please Help.

Thank you in advanced,

ExcelNoub

Here is a test sheet

Test.xlsm

I have not inserted the code in sheet2. Initial code is in Sheet1.

The restriction should be in between row 5 and 30. If 002 is inserted in Column B then it will add one row. That I dont need. I need it just to add the information.

Will try this tomorrow and let you know,

Thank you HaHoBe

Works like a charm,

This simple I need more coffee...

Thank you HaHoBe