sort by range

Hi Folks, Sorry if I sound silly. But, is there a way to sort by the last two digits before the hyphen, without removing the numbers after the hyphen? ie. 12306-97 , 123000-17, 154312-15, 965434-18, etc. I can do this slowly by combing through the spreadsheet but it is inefficient and I end up...

I need help with writing a macro to select to the last row of a given range of columns. My data is in the range of A:I. I need to sort first on column B, then sort by Column C. Here is the code I have thus far. But I cannot get it to execute without giving an error "Unable to get the Sort...

Hi All. Just after a little help to get this loop to work. I need to sort 100 columns individually so I can export the data to a report. I have tried adapting the sort code to run on a loop 1-100, but I am missing something as I cant get it to run. If anyone has any idea what I am doing wrong...

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 I am trying to save some processing time by reducing how much the computer needs to sort. Currently I have it set for 90,000 rows to handle the variable amount of information. I was wondering if there was a way to set the sort size based on how many rows actually have values/information in...

Hello! I need help guys, I have the filters at the top but i dont know what to do next. I want to be able to click the filter above the state abbrev column, sort by for example FL (for FLORIDA) and have all of the phone numbers populate on the right that begin with the area code that belongs to...

I have a macro attached to a button (each sheet actually has 4 macros attached to four buttons... but they are all virtually identical). Macro to sort range A5:E5 downwards (sorting by column A) works perfectly, until data is added to column D. When any data is added to column D the top row of...

This seems like a simple question, but i don't have the answer. I wish to Highlight any range of rows, then use a MACRO to sort it by Column "M" in Ascending order. Can anyone help me with this please?