How to set up the steps for creating code

Hello. What are the steps for creating the shell of a code? I have a lot of problem with the logic (looping, etc.) and I wanted to know how you should approach writing code when you know exactly what you would like to do in excel. Obrigado.

Sorry copied wrong text.