Hi all,
I need some help in sorting different sections based on values in a column. I have attached a sample workbook to help show what I am talking about.
So basically each section will have a different amount of lines everytime and they will be numbered differently, so basically I want a macro that can recognize the different sections (regardless of how many rows) and then sort the rows based on the the values in column smallest to largest.
-Thanks!
1. You should put the section numbers in a separate column (e.g. A) Needs a macro)
2. Delete the section cells/rows and all those blank rows and sort on department and priority or source (you don't specify). < preferred choiceyou can use conditional fomatting to highlight the start of each new department
Ben Van Johnson
Can this all be done via a macro?
Please Login or Register to view this content.
Thanks for the code, but it doesn't really work, it only changes one row in the third section. I hit it again and then it changes one row in the second section.
Hi Thelegazy,
try it
Please Login or Register to view this content.
You didn't specify which column to sort. But nilem's is neater.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks