How to duplicate worksheet with macros and have macros work in new sheet
I have an Excel workbook with a worksheet that has 3 macro buttons on it, each which sorts and filters a table on the worksheet in a different way.
I would like to copy the worksheet with macro buttons to a new worksheet and have the buttons work on the new one. When I copy the worksheet now, the macro buttons on the new worksheet bomb out. I believe because the macro buttons are trying to operate a macro hard coded for another worksheet.
Is there a way to change the macros of the copied sheet easily so they work correctly? Or should I have created the macros differently so they aren't looking for a specific worksheet?