I want to record a macro in excel but use it in different workbooks. I
export data from a webpage and want to write a macro that I can use
when I export the data to a workbook.

I recorded a macro but it only lets me save it in a workbook.

I also want to be send the macro to others so they can use it for the
same purpose.

All assistance is greatly appreciated.