excel vba courses - IT

a macro is basically a 'recorder' that records everything you do whilst you are making a macro. It's useful for tasks that have to be done many times, such as sorting a list daily.

go to tools > Macro > record new Macro and do some stuff like move from sheet 1 to sheet 2


then press stop on the macro recorder.

Now, go back to sheet 1 and go tools > macro > macros

select the name of the macro you just made and it will take you from sheet 1 to sheet 2.

This can now be attached to a button thru the drawing toolbar and you can use that button to move to sheet 2.

Hope this helps

Paul