Hello, I would like to make a macro in excel that I can use for any
spreadsheet. We constantly get reports and I would like to make a macro that
performs the necessary tasks for each one. However, whenever I make a macro,
it seems like it can only be used for that certain report. Is there a way I
can make one that I can just use for any spreadsheet?



Here's some more information, the sheets contains names, addresses, phone
numbers and other information in their own respective columns. I want to take
only the phone numbers and place them into a text file and at the same time
have a dialog box that prompts for the user's phone number and adds it to the
end of the text file. Finally, Outlook should open up with said text file
attatched.

However, the problem isn't creating the macro. It's the fact that I cannot
seem to find a way so that I can use the macro for multiple reports, as we
get many reports. Whenever I made a macro, it seemed like I could only use it
for the spreadsheet that happened to be opened when I needed to reach the
script editor.



I'm using Excel 2003. I want to use this macro for different
worksheets/workbooks too.

Thanks in advance.