Macro

Hello Helen

Thank you for your question and welcome to the forum.

To create a macro, you need to have the Developer ribbon showing in Excel 2007.

If the Developer ribbon is not showing, then:

1. Click the Office button (top left corner) then select Excel Options.
2. Under the Popular category, tick the checkbox for Show Developer tab in the Ribbon, and exit Excel Options.

To create a macro:
1. Go to the Developer tab, and in the Code group, select Record Macro.
2. In the Macro name box, enter a name for the macro.
3. Assign a shortcut key if you like.
4. In the Store macro in list, select the workbook in which you want to store the macro.
5. Include a description of what the macro does, if you like.
6. Click OK to start recording the steps/actions you perform next.
7. When you have finished recording your macro, go to Developer tab, and in the Code group, click Stop Recording.

I hope this helps.
Amanda