Added Macros together via Record need to loop at change in cell value

[kac1125]

Hello,

I have merged several Macros together via the record button. What I want it to do now is to repeat itself at a change of value in column A. For example A1-A10 are the same I would want it to run for those. Then A11 is different, I would want it to insert a row and run again and so forth. Please let me know if you have any thoughts:
This is my code after I recorded them all together.

Sub Final()
'
' Final Macro
'


'
Application.Run "'Copy of Order Create Template.xlsm'!Step1"
Application.Run "'Copy of Order Create Template.xlsm'!Ne"
Application.Run "'Copy of Order Create Template.xlsm'!adjpallet"
Application.Run "'Copy of Order Create Template.xlsm'!AdjWeight"
Application.Run "'Copy of Order Create Template.xlsm'!test4"
Application.Run "'Copy of Order Create Template.xlsm'!test5"
Application.Run "'Copy of Order Create Template.xlsm'!test6"
Application.Run "'Copy of Order Create Template.xlsm'!test7"
Application.Run "'Copy of Order Create Template.xlsm'!test8"
End Sub

Thanks in advance.

 

[ravishankar]

Explore

private sub worksheet_change(byval target as range) and
if not intersect(target range()) is nothing then

Ravi shankar