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
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