Tech Support Forum banner
Cancel

[SOLVED] Autosort 2 seperate tables same worksheet

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

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

Attachments

Save
Like
D
Re: Autosort 2 seperate tables same worksheet

Dragoen said:
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
Click to expand...
DragoenAs always... You rock! Thanks a bunch!
Save
Like
1 - 3 of 3 Posts
Status
Not open for further replies.
Tech Support Forum
A forum community dedicated to tech experts and enthusiasts. Come join the discussion about articles, computer security, Mac, Microsoft, Linux, hardware, networking, gaming, reviews, accessories, and more!
Full Forum Listing
Explore Our Forums
Windows XP Support Windows 7 , Windows Vista Support Motherboards, Bios|UEFI & CPU Networking Support Laptop Support
Top