There are lots of beginners and intermediate people here as well as a few
gurus. You're in good company!

Macros in Excel... Well!! Where to start?! The very simple answer is that
they make life simpler.

Initially macros can be used to *record* things you do. I had a user
recently who got fed up of inserting a Tick symbol from windings all the
time... So he wrote a macro  to do it and set up a button for it. When he
clicks the button now, the symbol is inserted... without having to click
Insert, go to windings, sort through the symbols for the tick and insert it.

They can be that simple.

And of course they can get very complicated too. I think it's true to say
that almost anything you can do in Excel with menus you can automate with a
macro. You can also do very much more.

Have you got a project you are working on at the moment?