RE: macros
Hi Laura
To record a macro do the following:
1. Open the Tools menu, select Macro and then click Record New Macro.
2. In the Record Macro dialog box, type a name for the macro in the Macro name box.
NB Macro names must start with a letter and can include letters, numbers, and underscore characters, but can't include spaces. You don't need to change the other boxes.
3. When you click OK, the Stop Recording toolbar appears, and you're ready to record. Until you stop the recording, every Excel command and keystroke will be recorded in the macro, in the order in which they are entered.
4. To finish recording the macro, click the Stop Recording button.
Hope this helps
Carlos