I'm working in a file with multiple tables on each worksheet. Basically, there is a template worksheet that I copy every day and update with new daily values. There are three tables down (each with 20 rows and 10 columns) and four across. What I'm trying to do is create a macro that sorts each table by the rightmost column. I can record the macro just fine, but the problem is the copying of the template worksheet everyday. The macro only references the that worksheet. Is there a way to edit the macro code to execute only on the active worksheet? Could there be anything else that I'm missing here? Thanks for any help.