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

kac1125

New Member
Joined
Jul 31, 2014
Messages
36
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.
 

Some videos you may like

Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"

Watch MrExcel Video

Forum statistics

Threads
1,089,862
Messages
5,410,856
Members
403,331
Latest member
dignityy

This Week's Hot Topics

Top