[daverupe]

I'm back at it again! This is very similar to the thread http://www.techsupportforum.com/for...ed-on-data-from-another-worksheet-552259.html

I've expanded the original scope to include more teams and add divisions. I can auto sort one division based on the instruction from the other thread. I would like to autosort the other division the same way. Attached is a copy of what I have thus far.

Range A1:A5 sorts fine. I would like to additionally sort A7:I11 on the Standings worksheet.

 

[Dragoen]

Re: Autosort 2 seperate tables same worksheet

Hi Dave,

All I did was copy and paste the block of code that does the sorting and altered the second block to sort the A7:I11 range. Now both sections will be sorted when the page is selected. Right click on the standings sheet tab "Standings" and select view code.

hth

 

[daverupe]

Re: Autosort 2 seperate tables same worksheet

Hi Dave,

All I did was copy and paste the block of code that does the sorting and altered the second block to sort the A7:I11 range. Now both sections will be sorted when the page is selected. Right click on the standings sheet tab "Standings" and select view code.

hth

DragoenAs always... You rock! Thanks a bunch!