Macros

Hello Dilly

Thank you for your question.

To create a macro in Excel 2007, you need to use the Developer tab.

If this is not visible in Excel, go to the Office Button, and select Excel Options. Then ensure 'Popular' is selected from the left hand side of the screen; and tick the box that says 'Show Developer tab on ribbon'; then click OK.

Once you can see the Developer ribbon, click the Record Macro button.

Give your macro a name (with no spaces), then click OK. You have now started the Macro recorder.

Go through the steps you would like the macro to peform for you, then go to Developer tab, and click Stop Recording when finished.

Kind regards
Amanda