Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro Order Rank
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! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro Order Rank
It would help if you posted the code. specifying the sheet in the macro usually solves this problem. Something like this for each sht in sheets with sht range("A1") = sht.name end with next sht the above code will go through the entire workbook and put the sheet name of each sheet in cell A1. -- joel ------------------------------------------------------------------------ joel's Profile: http://www.thecodecage.com/forumz/member.php?u=229 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=197127 http://www.thecodecage.com/forumz |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Rank order with conditions | Excel Worksheet Functions | |||
Excell rank= I need to reverse the order | Excel Worksheet Functions | |||
Rank order of errors | Excel Worksheet Functions | |||
Order/Rank | Excel Worksheet Functions | |||
Tie breaking in a rank order | Excel Worksheet Functions |