unable to apply a procedure from a different module into one module

[Makwa]

I have created 2 procedures and named them macro2 and Macro1
Macro2 is formatting and cleaning data
Macro1 is to assign the values of column H to Colum G using an = formula
Macro2 is supposed to execute first then Macro1
Now the problem is when i run macro2 everything is fine except that it doesn't stop when all my sheets are exhausted instead it jump into a new worksheet and gives me an error
Then when is time to run Macro1 It automatically gives me an error and cannot start it
i have attached screenshots please assist.

Also rememeber that Macro1 was copied from Module2 to Module1

 

[Micron]

You have 2 different kinds of modules there. Sheet modules are related to a particular sheet so you can often get away without being specific, such as when writing
Range("A4").Select

Standard modules (e.g. Module1) have no such connection to a sheet. You cannot simply write Range("A4").Select because it has no idea what sheet you're referring to. Same applies to userform code - it would not know what sheet you meant either.

Posting pics of code sometimes works for obvious issues, but if it required testing, I'm fairly certain no one would want to type out your code manually. Consider posting code in code tags (vba button on posting toolbar).