excel training in london - Macros

Hi Sera,

Thank you for your question.

A Macro records keystrokes and the way to create macros is under the menu Tools>Macro>Record a New Macro. (Start recording and Stop)

I do not understand though what you mean by calculating 'a new number' for a spreadsheet? but if you record the procedure on one spreadsheet you should be able to copy it and do exactly the same actions on a different sheet. In fact once recorded (on the same computer) you can use the macro again and again

Hope that helps

Tracy