How to build a macro to sort data on every worksheet in EXcel?
I was trying to build a macro to sort data on every worksheet within Excel 2007. However, after recording the macro, the macro seems to only refer to the original worksheet. The macro does not work in other worksheet. Here is the sequence I used: 1. Start recording new macro. 2. CTRL+Pagedonw to go to next worksheet. 3. Data-sort 4. Stop recording. The above procedure works at the specific worksheet. However, when I run the the macro, it does not sort the new worksheet. By the way, I used the same procedure in Excel 2003. It worked just fine then.
