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
Bookmarks