In Excel I have a sheet called Client 001 and a button that activates a macro which creates a number of rows then copies a template from another sheet into the new rows. It works great. Now that I have multiple clients however, I find I have to create the same macro for each sheet and change the section in the macro that says Sheets("Client 001").Select to the new sheet name. I have 20+ of the same macro now, making sure each button is assigned the proper macro. Is there an easier way to do this? To be able to use only 1 macro would be great. If I update 1 I now have to update 20+ macros so that all sheets work the same, it's time consuming.
Solved by V. U. in 26 mins