Tech Support Forum banner

[SOLVED] Autosort 2 seperate tables same worksheet

694 Views 2 Replies 2 Participants Last post by  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.

Attachments

Status
Not open for further replies.
1 - 3 of 3 Posts
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

Attachments

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!
1 - 3 of 3 Posts
Status
Not open for further replies.
Top