Sorting Multiple Sheets With One Macro

[Tubtech]

In the workbook provided im trying to write one macro to work on 10 sheets. I'm want the table H26:U45 to be sorted by the value in J26. I can write a macro to work on each sheet individually, (as you can see) however, is there a way to write one macro to be called from each worksheet individually and not update all 10 at once? Thanks in advance!

[ranman256]

Please Login or Register  to view this content.

[Tubtech]

thanks for the help, but i just wanted it to work on the one sheet it was called from, not all sheets at once. thanks again.

[jolivanes]

A quick way would be to change this

Please Login or Register  to view this content.

to this

Please Login or Register  to view this content.

[Tubtech]

maybe im explaining this wrong. if im on sheet 2 I want to run the sort macro on just that sheet, if im on sheet 6 run it on just that sheet. If i write a macro for each sheet it works just fine, just hoping for one macro to be written.

[jolivanes]

Did you try what was suggested?
If you change as suggested and run the same macro (in this case the macro for week 3) from any sheet, what happens"

[jolivanes]

Please Login or Register  to view this content.

I have not looked at any other changes that should be done but if this does what you want for all sheets you should be on your way to being a star.

[Tubtech]

i tried what you said in the first post and didn't get it to work, however I was sidetracked several times, I tried the new code and it works like a charm! I don't know how to thank you enough other than adding to your rep! Once again (Hand Shake) thank you I learned something today !!!!!

And Now with no interruptions I tried the first way once again and that worked as well, thanks once again!

~Bob

[jolivanes]

Good to hear all is well now.
Thanks for letting us know and good luck.

As I mentioned, just a quick way to get you back on track. Normally I would extract the index number of the open sheet and use that.
There are many different ways of doing it and maybe someone will jump in to show a different way.

[jolivanes]

Does this do the same thing for you?

Please Login or Register  to view this content.

[Tubtech]

that one works as well and is a lot more concise, you're great!