Hello,

I currently have a workbook with 36 sheets within for a production report.
The workbook is set up with a 1 monthy total sheet, 5 week total sheets and 6
days sheets per week. I also have a macro set up on one sheet that will auto
rank one (production) column which then would re-arrange the employee's names
from highest to lowest based upon the (production) column. Here is the
problem I would like to apply this macro to all 36 sheets, however, when run
this marco it will only adjusted the the sheet where the macro was originally
created upon. Now I could just create separate macro for each sheet, however,
that would consume much of my time. Is there an easier way?

Thanks!