custom sort

Hello - I'm having trouble developing a custom sort code that uses values in a named range for the sort options, and was hoping that someone could point out what I overlooked - I just started using sort codes yesterday, and the Range.Sort syntax provided by Microsoft is less than helpful.. I'm...

I am trying to use VBA to create a custom sort list for a pivot table based on the order of items on wkst SortLst. My Pivot table is is Sheet2(Company Wide). I am getting subscript out of range error. Sub PivotTableSortUsingCustomLists3() Dim rng As Range Set rng =...

Hi I'm having some problems with a custom sort in a macro I've made. Below is the extract of the specific piece of code, the error occurs on the penultimate line where it tries to apply the sort. This part of the code is right at the end of the macro (it's rather large hence not posting all...

Hey all! I've got a few problems but they're all related to the same thing I'm trying to do, so I'm just going to group them all together in this post. I'm using Windows 7 and Excel 2010. Sorry in advance for the wall of text! First problem: I'm having a hard time trying to create a custom...

Hi there, I am new to this forum. I have a question regarding excel and would appreciate it if someone could help. Basically, I have 3 sets of data with the following columns: A B C D E F AB 10 AB 9 AC 5 BA 10 BA 10 BA...

Hello everyone, I'm having difficulties creating this copy and delete text for my batch program. I have this sheet: <tbody> Data Data New Data New NL Data New FR X_SUPPLIER_1000057 XEN_SUPPLIER_1000057 XNL_SUPPLIER_1000057 XFR_SUPPLIER_1000057 X_SUPPLIER_1000058 XEN_SUPPLIER_1000058...

Hi all, For the following piece of code, I am getting a Runtime error '13', Type Mismatch Error when it reaches the following piece of code ActiveWorkbook.Worksheets("3. PMO Internal View").Sort.SortFields.Add Key:= _ f, SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:= _...

Hi All, I am quite new to excel. I have a requirment. I have rows of Data that comes from a source Something like below <TBODY> #NULL# 30 Aerospace 50 Black 70 Catamarin 30 Total 210 </TBODY> This has to be sorted as below <TBODY> Aerospace 50 Black 70 Catamarin 30 #NULL# 30...

I have monthly reports that need to be sorted in an order other than ABC. I have the proper order of each product, and the list is 79 separate items/rows (over 2,500 characters). I tried to create/import a custom list and ran into the character limit. How can I set up some sort of lookup...

Hi Everyone and thanks in advance for your time, Basically, I have a sheet that shows time in Days going downwards (monday tuesday etc.) and is broken out by week. In Column C, I have Project Names. Columns G-O have numbers. What I need to do is run a custom sort multiple times down the...

Hi, I have a spreadsheet where I am after a custom sort marco to run open spreadsheet opening. I have colum1 a titled "status" and the status entries are: 1) Not Booked 2) Booked 3) Completed 4) blank cell I have another column2 titled "Date" I am wanting to sort the firstly by colum1...

Hi, I have found many macros for sorting multiple sheets by a single column in Excel, however I was hoping someone had a macro for sorting multiple sheets by column "A", then column "B". Let me know if you need any more information. Thanks in advance. Cheers, Glenn

Good day, Using Excel 2007, I've successfully created the code needed to custom sort a pivot table when a particular field is selected as the first item in rows. Since this report will have multiple users, I've also coded to add the required custom list. My problem... The code calls the...

Hey there, I'm working on code which loads data into multiple pivot tables in a user form. I want to sort some tables to be sorted alphabetically, and some to be sorted custom (specifically, AAA, AA, A, BBB, BB, B). I'm new to VB and not sure if there's a sorting property for the PivotTable...

Following is the sample of my data which has to be sorted: http://www.box.net/shared/npktk537id What i need is that the data should first be sorted by family sr no., then in that family, first head of the family should figure (code 1), then his wife (2) and then the rest members of the family...

My excel book contains, A1 1 2 3 4 5 6 3 4 5 6 1 2 1 2 3 4 5 6 6 Now I want to arrange this from 1 to 6. set1:cell A1 to A6 is already in ascending order set2:Cell A7 to A12 data is jumbled with 3,4,5,6,1 and 2 set3:In Cell A19, 6 has been repeated.which i want to retain with in this set as it...

For my spreadsheet, I always use the same 2 custom sort criteria, so Excel typically remembers what those 2 criteria are. However, the past 2 days, when I try to custom sort, the box comes up with about 100 levels of custom sort, and its the same 2 criteria that I always use, but its repeated...