Solved

Sorting Sections again, this time on different sheets

Posted on 2011-09-26
5
148 Views
Last Modified: 2012-05-12
Recently I asked for help sorting sections on an Excel spreadsheet.  I have three sections separated by blank rows and I want to sort the first section by the last column and have the other 2 sections sort the same way as the first.  I received a solution that worked great and I really appreciate it.  Now I'm wondering if I can do the same thing but I have an additional three sections on another worksheet.  So the sheet I used originally looks like the attached.  I would have another sheet with three similar sections (different metrics) and would want them to sort when this sheet sorts and to sort in the same order as the first section on the first sheet.

I hope this is not too confusing...
testworksheetforsort-r5.xlsm
0
Comment
Question by:dkcoop03
  • 4
5 Comments
 
LVL 10

Expert Comment

by:SANTABABY
ID: 36602412
Please the attached file, you need to indicate the full path of the second workbook that you want to sort as well.
Please let me know if this works for you. The assumtio is : we are also sorting in sheet 1 of the other workbook.
If you need more exception handling code (such as second workbook does not exists etc) can be added.
t1.xlsm
0
 

Author Comment

by:dkcoop03
ID: 37018589
Sorry I am so late in responding.  I think I was unclear.  I don't need to sort another workbook, just another sheet in the same workbook.  So the first worksheet has the sort button on it and has three sections.  The sort button sorts the first section and the following two sections sort the same way as the first section -- this is all done on the same worksheet.  The next worksheet (right after this first one) does not have a sort button on it because it also has 3 sections and they need to be sorted in the same order as the first section on the first sheet.  Let me know if this makes sense.

Thanks,
0
 

Author Comment

by:dkcoop03
ID: 37122532
I've requested that this question be closed as follows:

Accepted answer: 0 points for dkcoop03's comment http:/Q_27328462.html#37018589

for the following reason:

I came up with a solution that is kind of messy but it works for now. &nbsp;I basically create an index on the first sheet and match the second sheet to that index and then sort.<br /><br />Thanks for your help
0
 

Accepted Solution

by:
dkcoop03 earned 0 total points
ID: 37122533
Sorry I didn't mean to accept my own solution.  There really was no solution given but I was going to give the points to the responder anyway.  I'm not sure what to do in the case where no solution worked.
0
 

Author Closing Comment

by:dkcoop03
ID: 37158277
I created an index from one sheet to another and then used the match function but included sheet names
0

Featured Post

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

Suggested Solutions

Approximate matching with VLOOKUP and MATCH seems to me to be a greatly under-used technique, and one which is vital for getting good performance out of large lookups. Until recently I would always have advised using an exact match for simplicity an…
Improved? Move/Copy Add-in Replacement - How to avoid the annoying, “A formula or sheet you want to move or copy contains the name XXX, which already exists on the destination worksheet.” David Miller (dlmille)  It was one of those days… I wa…
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

759 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now