Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    Excel


Auto Sort Code

Need to add an auto sort code to the end of this worksheet module 2, so that after all the dates are figured, it will sort by this date, no matter how many dates there are.

View Complete Thread with Replies

Sponsored Links:

Related Forum Messages:
Auto Sort Macro Code
I have a spreadsheet to create with columns A-I, this will be used by others when I am away and the problem is I dont want them to have to keep going into the data-sort option. Is there a way that I can get the items to auto sort into alphetical and numerical order across the columns? Personally I would be happy with sorting the columns manually each time it's accessed but I know the others using the program won't be!! How would it work if its poss? would it auto sort on saving?

View Replies!   View Related
Auto Sort
I am trying to figure out how to auto sort information on a spreadsheet so that when update notes are added by date at the bottom of the list, they are automatically sorted (moved) to the top of the list so the latest update is shown first. I am pretty clueless when it comes to macros although I have given it some attempts after reading other posts without success. I am including a copy of the spreadsheet. The info that I need sorted starts at B43:E43 and goes to B104:E104. That same sort info would then be used for the similar info to the right of this one. For example everything on the line B43:E43 would move together.

View Replies!   View Related
How Can I Auto Sort
There are only 3 columns, A, B, C and only 10 rows but I would like it to sort automaticaly. I enter data on other sheets and it is loaded automaticaly back to sheet 1 after some calculations are made. I would like the data on sheet 1 to sort automaticaly on column C keeping the rows of data intact.

View Replies!   View Related
Auto-sort In Worksheet
I have a worksheet in Excel which contains scores for a quiz I am organizing. The rows contain the team names, the columns the scores per round per team.
I would like to have the worksheet automatically sort the columns in descending order (so that the winner will come out on top after the quiz has finished), everytime I change something (everytime a score is updated). I can't find anything in Excel which would allow me to do that, so I'm guessing it's only possible in VBA? Unfortunately, I don't know anything about VBA, so I'm stuck.

These are the ranges I would like to have sorted, in order of priority:

Row 1 is the row with the column titles (Round 1, Round 2,...).
C2: C26

View Replies!   View Related
VBA Auto Sort The Column
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

View Replies!   View Related
Auto Sort Set Range
I know that I could just click sort, decending, "points" etc but I figure there must be a way of it auto updating.....

Please see the attached file - I have attempted doing it with Ranking Formula but forgot that it would just give me error messages when two have the same points so I got rid of that.

Have tried doing it with other formula found on this website and others, however I appear to be stuck. I might be doing it wrong but as I'm not manually putting in the "points", they are being worked out with =( SUMPRODUCT((H4:H16={"W","D","L"})*({3,1,0}))+58) for example, it does not move their position.

What I would like it to do:

1. People select from drop down list whether they think the team will W, D, L
2. The Table to the right should automatically change the points dependant on the result
3. The Teams position should change automatically in line with their new points total.

View Replies!   View Related
Auto Sort Alphabetically
is it possible to auto sort data using VB script?

as i know i can manually do it but i would like to run a script to sort data on sheet 2

View Replies!   View Related
Auto Sort Of Data
As you can see from the attached spreadsheet. I have a page called Pattern Etch where we enter the data for all the processing done in a single machine.
Each device type is slightly different, and therefore has a different calculation fasctor for its etch time. This all weorks fine. What I had previously was another spreadsheet with the pages b and g in it. This is where the factors are calculated and updated from.

I'd like to make this update automatic, and suspect the easiest way is to combine the two spreadsheets, as in the attached version. Can the sorting of the data from the patternetch page to the apprpriate pages, b and g be done automatically? If so can it be done for many pages as I have cut down the spreadsheet, I actually have 50 variants, each will need its own page (as for b and g).

View Replies!   View Related
Auto Filter Won't Sort
For some reason I have a worksheet that won't sort stuff by Autofilter any more. I built it as a customer database but for some reason today I just can't get the names to ascend or descend. there is something simple I can check for, I can post an empety sheet if needed but right now I can't really post a list of all my customers info.

View Replies!   View Related
Auto-Sort Columns
I am trying to create a VBA macro that autosorts a selection of columns by column A. I currently have the below already written which gives the desired effect. I was just wondering if there was a way i could have this script constantly running on the sheet so it is always sorted correctly without me having to click Run Macro everytime.

Sub Macro1()
Selection.Sort Key1:= Range("A1"), Order1:=xlDescending, Header:=xlGuess, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom
End Sub

View Replies!   View Related
Auto Sort Table
I've written a fantasy football programme, however i'm having trouble getting the table to auto sort. alter one of the values in the wins tab, then goto the scores tab to see that they don't auto sort.

View Replies!   View Related
Transferring Data/Auto Sort
I am trying to combine rows of data, each 4 cells long from multiple worksheets into one master sheet. I need to know if there is an easy way to do this and also I would like to setup an Auto Sort if possible to automatically sort the rows by date.

The data that will be transferred is: Date, Amount, Description, and Company Billed. I have my workbook organized by a Vendor per worksheet and would like to have the data I enter inside the vendor worksheet to automatically transfer to the master sheet and sort by date.

View Replies!   View Related
Data Auto Sort By Date
I have a very simple excel with three columns Name (column A), Date (column B), Hours (column C). I want the excel to autosort upon opening so the data is sorted by date. I right-clicked on Sheet 1 and put this in (I found it online):

Private Sub Worksheet_Activate()
Application.ScreenUpdating = False
Range("B1").CurrentRegion.Sort Key1:=Range("B1"), Order1:=xlDescending, Header:= _
xlGuess, OrderCustom:=1, Orientation:=xlTopToBottom, _
Application.ScreenUpdating = True
End Sub

View Replies!   View Related
Auto Sort A List By Values
Is there a way in Excel to have a list of names with values automatically re-sort whenever any of the values change.

The default sort I have in mind is ascending by values.


Sydney 100
Boston 200
London 300
Moscow 400
Houston 500

The values change to:

Sydney 5000
Boston 250
London 8000
Moscow 300
Houston 50

I now want Houston 1st, Boston 2nd etc - automatically - without me having to do a sort again by Value.

View Replies!   View Related
Auto Sort Macro On Column Changes
How would you right code to automatically sort (using the same sort parameters all the time) when the value of a column changes?

Here's the scenario:
Columns B through N are populated.

The sort parameters are (in order) column F ascending, column D ascending and then column B ascending. The sort in column F is based on a custom list (but I doubt that matters here).

As far as the number of rows to select, it varies but there is always a blank row at the bottom of the selection.

What I am looking for is code that will sort the selection (currently its B4 through N37) in the above order automatically when the value in any of the selected rows changes in column F.

View Replies!   View Related
Auto Sort Drop-down List
Is it possible to autosort a drop-down list based on the number of times an item is selected? A drop-down might have 500 lines so it is user-friendly if the top lines are those selected by users the most often.

View Replies!   View Related
Auto Sort Table Without Macros
Saw quite a few threads on auto sorting but nothing that solves my problem: Sheet 1 has two columns, column A has names and column B has numbers. These numbers are manually entered, and there are duplicate values.

Sheet 2 has to present the same names and numbers in ascending sort order. I cannot use macros due to security restrictions. I can accomplish it using a combination of functions LARGE and INDEX, if the values are not duplicated. But that technique fails when there are duplicate values.

In other words, Sheet 1 has:

Bob 5
Joe 2
John 5
Sue 3

and Sheet 2 should auto sort these values and give us:

Joe 2
Sue 3
John 5
Bob 5

View Replies!   View Related
Auto Sort All Columns Independently
I am looking for some help with a spreadsheet I am working on, the purpose of this sheet is to record case numbers that I am working on.

This spreadsheet will have new information added to it regularly and the cases may not be in a sequential order.

What I have found is a code that will sort a column of case numbers into an ascending order upon opening the file. What I would like to be able to do is apply the same rule to all columns on that sheet.

I have included the current spreadsheet to let you see how far I got.

View Replies!   View Related
Auto Sort A League Table
I have a football pontoon league that works on goals scored, what I am tring to do is to be able to auto-sort the league on the right of the document when I amend the numbers on the table on the left of the document.

View Replies!   View Related
Auto Sort Not Working Correctly
I'm try to get the pos. placing in a auto sorted table to remain in place
i.e. 1st next to the top position. 2nd next tothe next position and so on down. but it keeps getting it wrong! I've tried amending the macro serval times but it makes things worse! Sorry can't attach the file, too big for this forum!!!!

View Replies!   View Related
Auto-sort In Excel(Soccer Table)?
Create a macro for a soccer table.
image :
sort all characteristics (Win,Draw,Lost and and so forth)

D2 =IF(B9>C9;1)+IF(B11>C11;1)+IF(C13
D3 =IF(C9>B9;1)+IF(C12>B12;1)+IF(C14>B14;1)
D4 =IF(C10>B10;1)+IF(C11>B11;1)+IF(B14>C14;1)
D5 =IF(B12>C12;1)+IF(B10>C10;1)+IF(C13>B13;1)
E2 =IF(B9=C9;1)+IF(B11=C11;1)+IF(C13=B13;1)
E3 =IF(C9=B9;1)+IF(C12=B12;1)+IF(C14=B14;1)
E4 =IF(C10=B10;1)+IF(C11=B11;1)+IF(B14=C14;1)................

View Replies!   View Related
Auto Custom Sort List On Certain Days
I have a fairly large watch collection as below which I wear on a daily rotating basis(!).

SINN 144

View Replies!   View Related
Auto Sort Table Upon Update Of Another Cells
I'm using a total of 20 Rows and 2 Columns. Each row has Column A for Description and Column B for Score. There are total 10 subjects with 10 noneditable rows, and 10 editable rows.

I'd like to protect column A and B for rows 1 to 10 and unprotect only Column B for rows 11 to 20. When any cells from Column B, rows 11 to 20 updates, I'd like to automatically sort columns A+B for ONLY rows 1 to 10.

Therefore, rows 1 to 10 need to be sorted based on the scores on Column B, and since rows 11 to 20 are just input fields, they are never to be sorted.

Column B for Rows 1-10 will be formulas and are based on Column B values from rows 11-20.

When a value in any of the rows 11-20 of Column B is updated, Range A1:B10 will automatically sort from highest score to lowest score (Column B).

Since Column B for rows 1 to 10 contains formulas and not actual values, would it throw off the order of things when sorting formulas?

the macro coding to perform this task.

Here is just a visual of what the spreadsheet will look like

....A B
1||A (B11)
2||B (B12)
3||C (B13)
4||D (B14)
5||E (B15)
6||F (B16)
7||G (B17)
8||H (B18)
9||I (B19)
10||J (B20)
11||A 10
12||B 9
13||C 8
14||D 7
15||E 6
16||F 5
17||G 4
18||H 3
19||I 2
20||J 1

The Bold are editable fields. and I want to use auto sort A1:B10 based on updated values of B11 to B20.

I have also attached the basic excel file that situates my concern.

View Replies!   View Related
Auto Find/Replace And Marco Sort
I'm looking for is something that searches all worksheets in the work book for occurances of A1 (shovel) and replace it with A2 (spades). The list will be about 100 cells long and the idea would be that I could copy a sheet called "replace" with this list in, run it and standardise all the terms in the list within that workbook. Does it sound feasable?

The other query I'm not sure can be done. When I've tidied all these 'names' to a standard one, I want to sort the data (sometimes rows, sometimes columns) alphabeticalled for instance by the A1 to A10, or by A1 to Z1. Simply using the sort option loses all the references as is doesnt change any cells linked to that cell. The only way I could think to make keep the other cells pointing to where they should is to cut and paste/each row/column in alphabetical order manually.

View Replies!   View Related
Auto Sort- Row Refernce Based On Cell
I am typing a number into Cell B4 (ex. zza4582) this number is a serial number that will be in many differnt cells in column "A" on a different sheet "Template Paste". On each row with that serial number I need the information from "A-I" to be copied in the main sheet starting on row 10 and continuing on from row to row depending on how many times the serial number is found.

View Replies!   View Related
Sort By Definition? And Auto-fill Lists?
I update a daily incident report that is sorted by priority of the request as well as the date/time. In the past, I've recorded and run macro's to add a number to a priority so that it can sort numerically. Lately I've been tasked with building similar functionality into more reports. I am wondering whether I can tell Excel what order to sort items into (ie "Sort by HIGH, then MEDIUM-HIGH, then MEDIUM, then LOW)?

With regards to auto-fill lists (for want of the proper name), I report on multiple IT systems that fall into six "system" categories. Is there a way I can set up the "System" column to automatically update the correct data once the IT service is entered, rather than manually look up systems category then click the relevant system in the drop down box?

View Replies!   View Related
Auto Sort Columns On Workbook Open
I have a worksheet with 10 columns, and an ever number of growing rows.

What I would like to do is to Sort Column 'B', along with all the
other respective data in the other columns, each time the spreadsheet
opens. I would prefer to use VBA or some other auto-launching event.

View Replies!   View Related
Auto Sort Values In Drop Down List
i had a list based on dynamic formula.When ever i update(Add or Delete) New items to my List the drop down list should also be updated and sorted in Alphabetical order(Ascending :Words Starting with A - Z). How do i remove the blanks in the drop down list whenever i delete the data in the Source Data.

View Replies!   View Related
Auto Update Formula Reference & Sort
1. Is there any way a Cell can automatically be updated? for example:

On Citi Bank worksheet, As soon as a deposit matures, I insert another row and enter new fixed deposit data on "Row 13", but then I have to manually change the references on "Row 4" so that it points to the new "Maturity date" and the "Interest" and the "Current balance".

Is there any way I can automatically update Maturity, Interest rate and Current balance as soon as I enter new deposit information.

2. On the "Fixed Deposit Report" worksheet. Is there any way the list of deposits can automatically sort based on the maturity date as soon as I enter the new deposit information?

View Replies!   View Related
Calculations To Manual Before My Code Runs And Set It Back To Auto When My Code Is Done Running
I am dealing with several very large spreadsheets using VBA to do various things. I found that my code worked well, but was taking a long time to run. The biggest time consumer was my use of the AutoFilter features. I have since turned calculations to manual before my code runs and set it back to auto when my code is done running. What are the potential consequences of my turning calculations to manual and then back to auto?

View Replies!   View Related
Auto Sort Values From Highest To Lowest Based Off Of Value
I need the close% column to auto sort from highest to lowest so that I can see at a glance who the top sales person is. I have conditional formatting for the top three but I would rather them auto sort by close%, can anybody help me with this. I have attached the file,

View Replies!   View Related
Auto Sort A Table As Data Is Changed In Another Worksheet
My problem this time is in regards to auto sorting a table as data is changed in another worksheet and is auto copied within the said table.

I.E. I need the Fax page (second last), the table has to auto sort based on column " C ". This is easily done using custom sort but can it be done automatically ? I want to lock the page so nobody modifies it.

I attached a copy of my work so far, using Excel 2007.

All the sheets are locked except " Player DATA " and " Fax ".

The password is " Moose ".

View Replies!   View Related
VBA Code To Sort Data - Run-time Error When No Data To Sort
I havet he following code which sorts data. If there is no data to sort I keep on getting a run time error. Could I add something to my code to prevent the run-time error, as sometime there won't be any data to sort. The code runs when I switch to the worksheet in question.

Sub SortMeetings()
Dim iCTR As Integer
Dim yCTR As Integer
Dim zCTR As Integer

zCTR = 11
For iCTR = 12 To 23
For yCTR = 1 To 10
If Len(Range("D" & iCTR).Offset(0, yCTR)) 0 Then
Range("AA" & zCTR).Value = Format(Range("D" & iCTR).Offset(0, yCTR), "HH:MM") & " " & Range("D" & iCTR).Value
zCTR = zCTR + 1
End If
Next yCTR
Next iCTR
Range("AA11:AA" & zCTR).Select
Selection.Sort Key1:=Range("AA11"), Order1:=xlAscending, Header:=xlGuess, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _
End Sub

View Replies!   View Related
Code For SORT Is Not Working
why my vba code for sort is not working here. When I do F8 it simply passes the sort code (the one in red) with no action happening. Why.? and do I need to do. Thanks.

Sub Macro1()
' Macro1 Macro
Sheets(1).Copy Before:=Sheets(1)
ActiveSheet.Rows("1:2").EntireRow.Delete shift:=xlUp
ActiveSheet.Columns("C:M").EntireColumn.Delete shift:=xlToLeft

With ActiveSheet
With Range("A1:C10000")
.Sort key1:=Range("B2"), order1:=xlAscending, Header:=xlGuess,_
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _

End With
End With

View Replies!   View Related
Sort Code In Macro
I have a sort function in one of my macro. Sometimes it works, sometimes it does not. I can't figure out why. I am trying to sort columns A-F and each column has a header.

View Replies!   View Related
Sort Data Without Using Code
Can a sorted array be produced from a table without using code? The attached sample gives a better idea of what I'm trying to do.

View Replies!   View Related
Sort Data With Code
I have a set of Data and I would like to order the data based on a column which is G and contains Dates. I would like to order the data Desc order but this must be done in VBA as its a monthly report and needs to be scheduled.

View Replies!   View Related
Code To Sort All The Worksheets In A Workbook
code to sort all the worksheets in a workbook...

View Replies!   View Related
Add Custom Sort List To VBA Code
I have a Macro that I have recorded that autosorts several columns for me. This works fine as I have 5 columns that need to be sorted in a particular way.

The problem is that I have a custom list which I stored using the: Tools>Options>Custom List tab. Now this works fine on my pc as I have the custom list stored on my PC.however the problem is when someone else uses it on their PC it may no longer work as they won't have my custom list stored on their PCs.

Is there a way to store the custom list in a Macro and then use that list to sort to the criteria needed. For example "One, Two, Three, Four" will not store in alphabetically, so hope would I be able to sort so that they would appear in a chronological manner? Below is the code for the Macro I recorded. As you can see one of the lines says "OrderCustom:=6"; this I am assuming is reading from the list I created.

View Replies!   View Related
Macro Code To Sort Data
i want to create a command button that would sort my data in descending order.

View Replies!   View Related
Sort By Date Macro Code
I have a column which has dates in format: dd/mm/yyyy - there are no headers in this worksheet.

I need to sort the worksheet according to the row date field ... but it's causing issues.

It is assuming the dd is mm ... and when i reverse the format to yyyy/mm/dd before sorting - then it assumes mm is mm BUT it keep sorting with dd, regardless of the month. with both ways, the assumptions are interchangeable ...

View Replies!   View Related
Sort Range Via VBA Macro Code
I recorded this macro - which was a simple copy and paste and then sort the results, however it works in excel 2007 and not in 2003. Even tried to record the same in excel 2003 and it still does not work. It seems to fail at the sorting stage

Sub sortprices()
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Application.CutCopyMode = False
ActiveWorkbook.Worksheets("Results").Sort.SortFields.Add Key:=Range("D4:D16") _
, SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:=xlSortNormal
With ActiveWorkbook.Worksheets("Results").Sort
.SetRange Range("C4:D16")
. Header = xlGuess
.MatchCase = False
.Orientation = xlTopToBottom
.SortMethod = xlPinYin
End With
End Sub

View Replies!   View Related
Sort Array In Macro Code
I have been trying to take a variant array that has 6 columns, output it to a new worksheet (although I would prefer to just sort the array but can't get that working - how I can do this please feel free), sort the worksheet by 2 different columns, and then move these values back into the original array. I think I have the dumping and sorting down but I can't figure out the putting back into the array part. Here is the code I have thus far. varRecords is the array I am dumping to the new worksheet.

Dim dumpSheet As Worksheet
Set dumpSheet = Sheets.Add
Range(Cells(1, 1), Cells(1, UBound(varRecords))) = varRecords
Range("A1:F" & numRows).Sort Key1:=Range("C2"), Order1:=xlAscending, Key2:=Range _
("A2"), Order2:=xlAscending, Header:=xlGuess, OrderCustom:=1, MatchCase _
:=False, Orientation:=xlTopToBottom, DataOption1:=xlSortNormal, _

View Replies!   View Related
Sort Code Only Executes When Debugging
Within the code I am asking excel to sort two difference worksheets with virtually the same code, except that one of the worksheets does not get sorted. If I step through the code, it works and the worksheet is sorted, but if I just run the macro the worksheet does not get sorted, as if the line of code in question is being skipped. Pointedly, my question is - Why does the code work while debugging (stepping through) but not when I generally run it?

Also, as far as the code is concerned, I am sure that the all variables contain the information I need them to and am also sure that any ranges created from those variables are also the ranges they should be. Here are the two lines of code that are supposed to sort. The UBOC cash sheet gets sorted, but the LNB cash sheet does not.

'Sort the UBOC cash sheet.
wsUBOC.Range("A5:G" & lUBOCRow).Sort Key1:=Range("A6"), Order1:=xlAscending, Key2:=Range("D6"), _
Order2:=xlAscending, Key3:=Range("G6"), Order3:=xlAscending, Header:=xlGuess, OrderCustom:=1, _
MatchCase:=False, Orientation:=xlTopToBottom

'Sort the LNB cash sheet
wsLNB.Range("A1:G" & lLNBRow).Sort Key1:=Range("A2"), Order1:=xlAscending, Key2:=Range("C2"), _ .............

View Replies!   View Related
Auto-date Code

The link above describe a VBA code for pop-up calender. I wondering is it possible to have the pop-up calender automatically display by just clicking on a cell in column A instead of pressing Ctrl C. The dates will be only in column A

View Replies!   View Related
Code To Auto-Save
Currently I have an excel form that I am working on. I just figured out how to get it to open when I open the workbook. I am wondering is there code out there that will prompt excel to auto save the worksheet that the form writes to when the "OK" button on my form is clicked. I want to be able to save the data without having to rely on the user to remember to save everytime entry is complete. if there is a code for this function, where would I place it in my code listing?

View Replies!   View Related
Auto Save - VBA Code
Is there a way to have excel automatically save the workbook every 5 minutes or so? I'm not talking about the backup option (tools-options-save) I mean do a hard save?

Or would this warrant a timed VBA code? If so, can someone build me one quickly? I'm kinda in a time crunch - sorry for last minute notice. Co-worker just deleted 8 hours of work bec "she didn't" know to save it....

View Replies!   View Related
Code Or Formula To Sort Multiple Entries
The tables given below located in different worksheets rather then doing autofilter(sheet3 hidden) is there any code or formula to sort them out.....

View Replies!   View Related
Amend Code To Sort Sheets By Number
I tried this macro, written by Leith, to organize a workbook of over 100 worksheets, all named as a 3 digit number. (001, 002, 007, 004, 018, 12, etc.)

For some reason, there was no order to the sorting. Can the macro above be modified to sort my sheets in numeric order?

View Replies!   View Related
Sort Code To Run Anytime The File Is Saved
I need the following sort code to run anytime the file is saved....I can't figure out what to title the sub and where to put it (ie. This workbook or in a module). I am attaching the file for reference. The file will not always be saved using the "save as" option - sometimes it is saved just by clicking the "save" icon

View Replies!   View Related
Copyright 2005-08, All rights reserved