Macro editing help

[Dan Wilson]

Good day. All of the desription following needs to be referenced to Excel 2003. I have a workbook that contains 12 worksheets. Each worksheet is formatted exactly the same. There are 5 Columns on each worksheet. Column A is named the same on each worksheet, Column B is the same on each workhseet, etc. Each worksheet has 250 rows of data, whether they contain data or not.

I have created 5 macros. Each macro will sort the entire worksheet by one of the Columns. The macros are named for their function: ex: sort_business_by_address_number, sort_business_by_street, etc. There are 5 buttons created in Column G (column F is blank for spacing). Button #1 is assigned to the first macro, button 2 the second macro, etc.

Since there are 12 worksheets, I would like to copy the 5 macros from the first worksheet to appear on each one of the 12 worksheets. That means creating another 55 macros identical to the first 5 with only the worksheet name being different in each one.

Is there a way to edit or copy the first 5 macros to create the additional 55 macros? I have tried using Visual Basic and editing the existing macros, but with no success other than to destroy and existing macro.

Any help will be appreciated.
Thanks, Dan...

 

[VoG]

Maybe look here http://www.cpearson.com/excel/VBE.aspx

 

[Dan Wilson]

Good day Peter. Thank you for responding so quickly. I appreciate the help. There is a lot of text to go through in the article that you referenced, so I will take my time and review it. I'm sure that the answer to my issue is in there somewhere.
Thanks, Dan...