Teach Yourself Excel Lesson Sort Data - Sort Data

I recorded a macro. Within the macro is a Data Sort including column RN.

For ease in reading the final printout I wish to interchange the data in columns RN & RM with a Cut command (not part of the macro)

Does the macro self correct or will I have to "write" (record) a new macro ?

Thanks,

Sam Marx


Please disregard thefollowing question on ACN.

Hi

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.

Code:

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, _
        DataOption1:=xlSortNormal
End Sub

Thanks

Hello all,

I need code for a worksheet that Data/Sorts by column B, of the current region (which is already highlighted via code) but I DON'T want to include the header row, nor the bottom-most row, which will be dynamic (I never know which row the bottom-most "totals"/Auto-Sum row will be in).


Can this be done?

Thanks

My table contains roughly 20 sortable columns. I'd like the users to be able to custom sort, but many of them are so novice that I can't rely on them to be able to find Excel's 'Data Sort' options from the menu.

Is there a way to have VB display the Data, Sort dialog box but not automatically sort the data?

Since many of the probable sorts will involve multipls keys, a simple VB 'Sort table by this column' macro wouldn't work.

Thanks!

The addresses are three rows each and in two columns. Do I convert the
columns to rows and then import the text file into excel? How can this be
done? Or is there another way?

I have this code which I modify for each scenario in any given workbook:
************************************************************
Sub Sort_Sheet_NotesFromPrograms()
'
ActiveSheet.Unprotect 'place at the beginning of the code
Application.Goto Reference:="R1C1"
Selection.Sort Key1:=Range("A2"), Order1:=xlAscending, Header:=xlGuess,
_
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom
ActiveSheet.Protect ' place at end of code
Range("A2").Select
Selection.End(xlDown).Select
ActiveCell.Offset(1, 0).Select
End Sub
************************************************************
The difficulty is that if there aren't at least two rows with data, I get an
error message. For me, that's fine. I know the reason behind the error box
so no worries. But I'd like to have better code so I can share these
workbooks knowing that even blank sheets will work flawlessly and the users
won't get flustered by these error boxes popping up.

Is there a way to incorporate something that will help in those cases where
there is not yet anything to sort?

TIA. Much appreciated. You guys, as always, are the best! :oD

I have a table that had a sort applied. Now, because of changes to the way the table is being used, I need to change the sort order.

Each time I attempt to save the file, it resorts to the previous sort order. Even when I save the file with a different name, it resorts to the previous sort.

Any help would be appreciated! Thank you.

I have a worksheet with data which is sorted by dates. Is there a way that I can add new data and have it automatically sort once it is entered?

I have a system that produces logs like the ones below. I only need the data in red, but I need it sorted in columns. In the example, "753" is in B2, 699Y is in C2. The first column of zeros is B3-B9, the 2nd C3-C9 and so on. I explained because it didnt paste correctly. What I need is on another spreadsheet 699Y in A1, the value of B3 (0 in this example) in A2, the value of B6 in A3, the value of C3 in A4 and so on. This is one log, but the sheet actually contains over 300 just like this. It skips one row and has another log. Is there a way to do this?

753





699Y






0



0



0



0



0



0



0



0



0



0



0



0



0



0



0



0



0



0



0



0



0



0



0



0



0



0



0



0

I am an inexperienced Excel 2003/Windows XP user who is in need of help in sorting rows of historical data.

I have many individual data files that have nearly 10,000 rows each of non header type ascii Excel spreadsheet data which has columns of A B C D E

I need to do a sort on each individual file for numerical value for each separate individual row that will place the highest value in each row for columns C and D, with C having the highest of the two values and D having the lowest of the two values.

For example if line 1 reads as follows:

20080411 1900 1900 2000 2000

then I would need a function or macro to change the 1900 and 2000 in columns C and D to show as follows:

20080411 1900 2000 1900 2000


Many of the rows are already in the numerical value order that I need already, so it is not just a simple matter of switching columns. I also need each row to maintain its own individual set of dates and values and with ONLY a change in the numerical value order between columns C and D for those rows which are not already correct.

Thank you.