Manase has attended:
Excel Advanced course
How to create lists in excel from data
Do you have to use macros
RE: 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.