How do I insert cells at certain parts of rows

If I explain what I need done it may be easier.
What is it at each change in column A I need the cells in the row above in columns F and G moving down one cell and then the row that F and G have been moved to I need that moving down one cell too.

I.E if Data changed at A10 I need the data in F9 and G9 moved down to F10 and G10 and then data in A-E10 moved down to A11-E11.

Can anyone help.I also need this to repeat all the way down the workbook where there is a change of data in column A. It will always start LTP BY its just the numbers will increase if that makes any difference.

Hope this makes sense.

Many Thanks

cross-posthttp://www.mrexcel.com/board2/viewto...406373#1406373