If you have my sheet open you can right click on a sheet tab and select "view code" then click on "Moduels" then "Moduel 1"

Depending on the type of macro you create they would go in different places but basic macros can go here.

They do a lot more than just emulate keystrokes every thing that is typed as a formula can be used as a macro so the sheet contains no formulas and runs super fast.

I don't do this myself but use macro to perform things i can't do in code, my main use of them over the years has been for extracting information from web pages i have imported and to automate these tasks.