excel consulting - How to create lists in excel from data

Manase,

Macros can be used for many things.
First find a process that you do repetitively.
Make sure you can do each step clearly. You can only automate or record something that you can already do.
Once you have the steps, then go to TOOLS > MACROS > RECORD NEW MACRO on the menu bar.
Complete the information in the window (name of macro, shortcut, description). Once you click OK, the macro starts recording. It records EVERYTHING you do, do be very specific about what you do. There is no time limit when recording a macro, so take your time.

Once you have completed the recording, click STOP and then you can replay your macro through the TOOLS > MACROS > MACROS menu.