Need Help with a VBA code.

[mbrackey]

Would anyone have any suggestions for a VBA that would allow me to automatically add a row into a spreadsheet that uses a cross reference or filter from the first four letters of one column, to a cell in another column?

Help desk.xlsx

Basically I want to be able to add another line into this example spreadsheet that will add another row below A4 (or any random cell in column A) when the document information is imported. It needs to line up with the asset numbe in Column L (on both the old number and the number directly below it. Basically what happens is when ne of our assets changes, the import misaligns the L, M, & N columns, with the old asset on the primary line and the new asset a line down until you hit the bottom and its just a row with only L, M, & N filled up.

I don't know if my explanation is terrible. Frankly I have been working on this issue for about 5 days with no success. I am not even sure that the request from my finance department is not just a whimsical fantasy.

Any suggestions or help would be greatly appreciated. Even if it is just telling me that it can't b done.