I'm looking to sort one column based on the values of another.
For example, if Column A has a list of names, and column B has a list of their ages, I just want to sort Column A based on the ages, but I want the ages column to stay as it is.
Is it possible to do this without a Macro? And if it requires a macro, how can I write a macro to make this work?
I want to be able to sort the columns in a worksheet based on their cell values, eg. column of text sorts A to Z and column of numbers sorts largest to smallest. Cells are formatted as General, number or currency but the sort button only offers A to Z or Z to A.
View 2 Replies View RelatedI have a spreadsheet that track orders. I want to be able to add a bit code to my current VBA script that sorts the data based on the values in a particular column (smallest to largest).
Current table looks like this:
Order Number
Date
Quantity
Colour
Priority
548562
12-09-2012
56
VBA formula
2
[code]....
I want to add be able to sort the data, smallest to largest based on Column E (tittle Priority)
I want to rearrange(sort asscending) columns based on numerical value in column header string through VBA macro. Please check attachment.
i.e. (Present Data)
# A B C D
1 col.1 col.4 col.3 col.2
(Output Data )
# A B C D
1 col.1 col.2 col.3 col.4
test.bmp
Using DataEntry sheet for data.
Trying to rearrange the data to DataFormatedProperly sheet.
So far all I can accomplish is DataFormatedWrong sheet.
Edit: Not sure what happened but file was NOT understandable before. It should be correct now.
Here's what I have.. (on a much smaller scale)
http://www.jmetenterprises.com/produ...pics/excel.jpg
(notice how the lines that match are now even.)
[Edited by admin~ *Link* to large images, don't display them]
is it possible to leave a column out of this sort code as in A the very first column which just numbers the rows?
Here is my sort ....
I'm looking for a way to sort dates from several columns into a new single column (perhaps multiple columns if the entry columns become too numerous). I've included an example. There are currently only 4 columns, but there may be as many as 20 in the future, each with 20 dates under each heading. Any blank cells would be eliminated. If I filled a blank with a new date, that date would be placed into the chronological column. So basically, this would take the date from several different categories and create a single calendar of events.
View 8 Replies View RelatedI believe that the best way to evaluate this request is to look at the example. I have 2 buttons to demonstrate what I need, along with written instructions.
eMailSampleTest.xls
i want to sort column D acsending, then column C descending. i want to do this using VBA because i cant just format the sheet because another vba macro paste the sheet thier which would rid the formatting. (i would do it myself everytime but it is for someone to make it easier for them and not make mistakes..i searched, just found a sum formula post)
View 3 Replies View Relatedcolumn A has random numbers 1- 10. Column B has numbers 1-10 also but in a different order. How can i sort column B to match Column A?
View 9 Replies View RelatedI have a list of people that I want to sort according to their age in ascending order. If several people have the same last name (family members), I want those to be sorted together. After clicking on the SORT-button the result should look like this:
[Code] ...
Attached File : Test2.xlsm
I want to sort row based on duplicate value in Column 2 & 3. And copy the content if Column 3 is Self-duplicate.
Hard to explain, something like this:
Column 1
131.74
1.63
12.31
Column 2
375-9323
384-803
267-6491
Column 3
375-9323
NO
384-803
267-6491
375-9323
Result should be like this:
Column 1
131.74
1.63
12.31
131.74
Column 2
375-9323
384-803
267-6491
375-9323
Column 3
375-9323
NO
384-803
267-6491
375-9323
I've been playing with different Macro and search quite a few places but haven't got any luck so far.
I have a data set that id like to sort via macro. The first two fields are not relevant to the sorting proces.(Column A & B ). Column C contains totals some are zero, some are greater than zero and some are less than.zero. I have a macro which I use for many reports that sorts based on Autofilter but I dont know how to change it so that I can use less than, greater than and = to 0. Below is my attempt which didnt work.
View 9 Replies View Relatedsorry for restarting this thread but i started one similar on saturday and the person I was talking to has not yet responded
I want to know if it is possible to adjust this code line:
Case "Monday", "Tuesday", "Wednesday", "Thursday", "Friday", "Saturday", "Sunday"
from the macro below to instead get the case names from a list on a worksheet... the reason for this is that the names of the worksheets I want sorted will change periodically.
Sub SortDaysoftheWeek()
Dim ws As Worksheet
For Each ws In ActiveWorkbook.Worksheets
Select Case ws.Name
Case "Monday", "Tuesday", "Wednesday", "Thursday", "Friday", "Saturday", "Sunday"
With ws
.Activate
.Range("A6:G256").Sort Key1:=Range("A6"), Order1:=xlAscending, Header:= _
xlGuess, OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _
DataOption1:=xlSortNormal
End With
End Select
Next ws
End Sub
I have one column of names that has been entered as "first and last name" as one entry and I would like to sort by the last name (the last word in the column). Some of the entries are simply first and last name (e.g. Jane Doe), some are spouses together (e.g. Frank and Elaine Smith) and some contain middle initials (e.g. John Q. and Amy X. Public).
View 2 Replies View RelatedThe below code works perfect, but I want to add to it so that if column F has a x rather than an eMail address, I don't want that row(s) included.
View 5 Replies View RelatedI have column a with the following names in A1:A10 with a corresponding number in B1:B10
Gold 7
Copper 1
Platinum 6
Brass 10
Aluminum 8
Carbon 4
Nickel 5
Iron 2
Titanium 9
Composite 3
I want to sort them from highest to lowest in C1:C10 & D1:D10. This meaning the part with the highest number would fall in C1 and its corresponding value in D1 and so on. Is this possible using a formula?
if it is possible to sort a range by a specific value in a cell in a column within that range. The reason I'm asking is that I would like to sort by street name in an address line, ie:
500 Aldavar Rd
32 564 Hughes Cresc
36 Aldavar Rd
14 263 Fairlane Ave
If these are samples in a column, I would like to sort, and have the following "output":
36 Aldavar Rd
500 Aldavar Rd
14 263 Fairlane Ave
32 564 Hughes Cresc
it is NOT critical that "36 Aldavar" appears before "500 Aldavar" in the output.
In every month I have to send report to each sales person provided one sales person should not get info of another sales person. Now I am doing it by making file after sort using copy and paste which is time consuming. Is there any way that I can make individual file for each sales person in shortcut way.
View 1 Replies View RelatedI have a worksheet which contains data for 6 different groups. I have a sort macro already that sorts them into groups (group 1, group 2, etc.) What I want to do know is set the Print Area so I can just print each group individually with a button("print group 1", etc.)
The worksheet is set up as follows:
Columns B-H are the data I want to have printed. The number of rows is different for each group. I want to set the Print Area based on Column H. So, if H=1, set the Print Area for Columns B-H and all rows that have H=1. This seems like it should be simple enough, but I haven't quite been able to put the pieces together yet.
do Different SORT based on data entry.
I have a macro in a workbook that looks like this:
I'm new here, google helped me to find this place. Hope someone here can help me a bit on my excel spreadsheet. I have one list of numbers and it need to be sorted under Perm condition so the list become shorter. The function should go through the listed number and output new list after sorting it. I have attached my excel here.
View 7 Replies View RelatedSee the attached spreadsheet. I have people's names in cells A2:A5. These names have a rank value in cells B2:B5. What I would like to do is create a formula that sorts/orders the names in cells A2:A5 according to the rank in cells B2:B5. The results I would like to achieve are shown in A8:A11. I am aware of the "Sort" function in the "Data" drop down menu, but need to leave cells A1:B5 as they are.
View 2 Replies View RelatedIn the attached spread sheet, i have two set of data, for two different months.Columns A to D have the value for the first month and columns F to I have the values for the second month. In the first set of Values i have the dollar value in the column "D" and in the second set of values i have the dollar value in column "F".
I want a macro, to compare these two cells and arrange the data accordingly. If both the values are the same, then both the lines corresponding to the values can remain in the same row. If one value is greater that other, then the set of values which have the lower dollar value should come to the next row. I have attachec the sample data. The lines highlighted in green is the raw data and the one in yellow is the finished data.
Is it possible for a column of "sums" to auto sort from largest to smallest? I have a dashboard with 20 charts and I want them to show in the order of largest to smallest but its rolling data so it changes daily.
View 6 Replies View RelatedNeed the formula that I will need in my macro to move to the next column (up one letter) for the next time I run the macro witout me having to manually change column the letter?
Is there a way to automatically sort a column in ascending order while entering numbers so that the column is sorted when last number is entered.
View 11 Replies View RelatedI have 5 columns of numbers and at the bottom of each column I want to list every number in order from least to greatest and how many times it occurred in the column.
I'll just provide you with 5 rows of numbers so I don't waste a ton of space.
0628313841
0814364045
0203193042
0105101518
2021233335
I have the below small code which auto sorts information in column A & B but I am having trouble trying to get it to sort from row 3 and not sort the first 2 rows. The first row is the column header the second row I want left blank and then sort after that.
Plus at the moment after I enter something into column A it auto sorts itself but what I would really like to do is have it commence the auto sort after I have entered information in column B and pressed "enter". Because at the moment I enter info in column A then it auto sorts itself then I must then find it and then enter the info into column B.
Private Sub Worksheet_Change(ByVal Target As Range)
Dim rg As Range
Set rg = Columns("A") 'Column containing names to sort
If Intersect(Target, rg) Is Nothing Then Exit Sub
Range("A:B").Sort key1:=rg.Cells(1, 1), order1:=xlAscending, header:=xlGuess
End Sub