Tech Support Forum banner
Status
Not open for further replies.
1 - 3 of 3 Posts

·
Registered
Joined
·
16 Posts
Discussion Starter · #1 ·
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

·
Grammar Nazi!
Joined
·
3,865 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

·
Registered
Joined
·
16 Posts
Discussion Starter · #3 ·
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