sort & filter

Hello All, I can't believe the response and how helpful everyone was last time. Hopefully I can get the same results this time around. Okay - I have a spreadsheet with multiple columns (A through N). How would one go about writing the macro to sort on column D where row 1 is "family name" and...

Hi, I've looked thoroughly throughout forums and tutorials for a possible solution to the following situation, but to no avail. It may have to do with the wording I use in my search, as it's difficult to know how to ask this, but I'm just stumped. I have a list of data, 50-200 rows a week, that...

Hello, I am having trouble adding the sort function into code that autofilters based off of criteria. I would like for this code to sort Greatest to Least based off of a specific column name ("Prior" or P in the code). I am also not sure if I should apply the filter criteria and then sort or...

Hello, I am using Excel 2013 on Windows 7 on a PC. I am attempting to sort a worksheet on several columns in my code. The rest of the code is dependent on this sort being executed sucessfully. I derived the below using the recorder, but even after a couple of modifications, the sort does not...

I have excel sheet with two columns (Employee Name and Technology).I need formula to filter data on technology column,instead of manually applying filter and sorting the data. Is there any formula which gives me the result to find out the employee name based on technology. (Example:If i want...

Hello, I would like to create a chart in another worksheet (starting at cell N4) that pulls data from the current worksheet labeled " Time" There are several pieces of data listed in "Time" but the only thing that I care about are three columns that arent' next to each other labeled "Name"...

Dear, I have a data which looks like below: Now in a next sheet I want to sort all the data which are answered (E column). using which formula i get all the information which are answered. Note: the data range is dynamic. Below is a sample of the after sorting.

I have a question about automatically ordering cells. I have cells that show as follows A B 1 |Cinthia 12 2 |Scot 20 3 |Mike 5 I would like to make it so these cells automatically order by highest to lowest. This number changes daily and I have been ordering them using...

Hello, I've trawled the net and found endless posts/replies about enabling filtering but disabling sorting, but couldn't find any about doing the opposite. I've got the following code in the relevant sheet (which I want to be protected upon opening): Private Sub Worksheet_Activate() With...

Good day All, i have a excel sheet with data as follows: <tbody> Name Amount Severity-1 Severity-2 Client1 45 4 6 Client2 80 7 8 Client3 65 5 6 Client4 70 4 5 Client5 90 6 9 Client6 35 8 7 Client7 50 6 8 Client8 60 5 7 Client9 20 8 6 Client10 90 7 5 </tbody> User will...