Need Help with a VBA code.

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.

Hi mbrackey

First you'll need to change your Thread Title

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum

Second...is there always only one of these misalignments in the worksheet or could there be several in the same worksheet? If several modify your sample to reflect that.

Third...please add an "After" worksheet to show the several examples properly aligned (your expected results).

Perhaps one of us can help.