sort columns

Hello, I'm trying to figure out how to sort columns independently of one another using VBA, and I have a good little piece of code that does this for me (see below). However, I've run into a couple of other things. Some columns may need a custom sort order, not just ascending. What does...

I'm working on a macro to make an exported report more useful. My intentions are to: Delete unnecessary columns make 30 new worksheets based on the names of "teams" and copy the data from the first sheet to those Now each worksheet has extra rows, delete the extra rows based on the value in the...

Hi, I have sort function - now only by column B. I want to have sort by column B,C,D. How can I add it to below code? x_row_sort = wsSORT.Cells(Rows.Count, "A").End(xlUp).Row Dim oneRange, aCell As Range Set oneRange = wsSORT.Range("A1:CT" & x_row_sort) Set aCell = wsSORT.Range("B1")...

Hi Excel Gurus, Does anyone know what setting should I use in order to allow a user to sort data in a table when some of the cells are locked? When I protected the sheet I ticked the option to allow user to sort data but it doesnt work... Any help as usual would be greatly appreciated... Cheers

Hi, I recorded sort funcion to sort my range. I made cosmetic changes. Dim wbS As Workbook Dim wsS As Worksheet Set wbS = ActiveWorkbook Set wsS = wbS.Worksheets("sheet1") x_row_sort = wsS.Cells(Rows.Count, "A").End(xlUp).Row wsS.Sort.SortFields.Clear wsS.Sort.SortFields.Add...

In my excel files, I have several columns: "No." "First Name" "Last Name" "Quantity" "Price" "Total" All the columns are sortable, which is expected - however, I would like for the first column to be "unsortable", meaning - suppose I sort the list by last name, I still want...

Ok this may be easy or it may be impossible. I have fifteen columns that each have a companion column. These columns have website types and then the adjacent column has the value for that type. So it would be column 1, "Facebook", column 2 is that contact's value for that type, such as...

OK here is my problem... I need to extract data from one main sheet to a couple of different sheets. That have been done by a excel genius for me. It work like a dream. All data is extracted as it should! See post...

I am trying to add a macro that finds a dynamic range (number of rows changing with different data sets) sorts column B, then column A, moving blanks to the bottom. My dilemma is as follows: I have a template with formulas that cannot be changed (I cannot paste special values, or clear the...

Hey guys I've got an issue with data sorting. My data looks like this: <tbody> A B C D 1 2 aa aa 2 12 bb bb 10 4 cc cc 7 11 dd dd 4 1 ee ee </tbody> I need it to look like this: <tbody> A B C D 1 1 ee ee 2 2 aa aa 10 7 4 4 cc...

Hi there, I wonder if anyone can help, I have part of a macro getting run-time error '1004', trying to sort columns J:K in a workbook with multiple sheets of similar format. Here is the code that gets stuck at ".Apply": Columns("J:K").Select Application.CutCopyMode = False...

I am looking for vba code to sort columns based upon values in another set of columns. The number of columns will change row by row, thus it needs to be dynamic in nature. For example, the first row may have the following fields in columns A-H: Field_A, Field_B, Field_C, Field_D, 3, 2, 7, 1...

Dear All, I am looking for VBA that will sort columns based on values I assign to labels of the columns. I use this on data where I want columns to be in a certain order. I have code that: Inserts a blank row above the column labels Puts a value in the blank cell above the column label...