Simone has attended:
Excel Advanced course
Macros
How to use the same Macro for different spreadsheets?
RE: Macros
Hi Simone, thanks for your query. As long as you macro does not have a particular reference to a named worksheet coded into it you should be able to copy it to another workbook using the following method:
http://office.microsoft.com/en-gb/excel-help/copy-a-macro-module-to-another-workbook-HP010014116.aspx
Just be careful your macro is as non-specific as possible or it might not work on your new spreadsheet.
Hope this helps,
Anthony