I am attempting to write a command button to insert a line between two lines that already have formulas in them. I would like to insert the row and have the forumals shift down, but not be the same as above. Sort of something like below.


1 003 1st Floor CHWS&R 1st Floor 500.00 287.50 212.50
2 004 VAV Connections 1st Floor 25.00 125.00 -100.00

I want the line to insert between A and B, but I want B to move down to C and become 005, and I want the new line in B to be 004. I want that consistent for the codes in 3, 4, and 5. Thanks for your help.

Thanks,

TJB