Free Microsoft Excel 2013 Quick Reference

Automatic Sort A to Z Help

I would like to sort Column B In Alphabetical Order. From A-to-Z automatically.

Column B C D E F G H I J K L M N O
John Smith x x 0
Don Cambrain X X X

I would also like information in C D E F G H ......, to move up and down with the name in colum B WHen it is listed in alphabetical order

So it would switch to
Don Cambrain X X X
John Smith x x 0

I know i am asking a lot, but i really need this. it would save me some time. Thank you soo much.

COLUMN B starts at B2 and ends at B236
information starts at Row 2 across to AG

I am very new to excel a beginner, probably rate myself 2 outta 10. When providing instructions please go into detail so a beginner can follow along. Like where to go to place the formula etc,....

Thank you soo much anyone who helps out.
Edit/Delete Message

Post your answer or comment

comments powered by Disqus
I need help with two related problems:

1) What macro do I need to run in Excel 2000 or 2003 that will allow a protected sheet to run an A to Z sort?

2) Assuming my first question is possible, is it possible to sort data on sheet 1, which will then automatically sort related data on sheet 2 and 3? Or do I have to individually sort each sheet?
For example, if on sheet 1 I have names and gender of pupils, on the second sheet I have the pupils spelling test grades and on the third sheet is their maths grades. On both the 2nd and 3rd sheet the name and gender are taken from sheet 1, i.e. they automatically update when a new name/gender is entered or names are sorted. And there lies my problem, if I sort the names on sheet 1, they will automatically sort themselves on sheet 2 and 3, but the other data doesn't. Any ideas to solve this problem will be gratefully received.

I have this formula for sorting sheets, but I don't want the option of sorting from Z to A to be an option. It would be good it the only options were YES (sort A to Z) and Cancel (no sort at all).

Sub Sort_All_Sheets()
' Sort_All_Sheets Macro
' Sorts all sheets from Ascending or Descending mode

Dim i As Integer
Dim j As Integer
Dim iAnswer As VbMsgBoxResult
Application.ScreenUpdating = False
' Prompt the user as which direction they wish to
' sort the worksheets.
   iAnswer = MsgBox("Sort Sheets in Ascending Order?" & Chr(10) _
     & "Clicking No will sort in Descending Order", _
     vbYesNoCancel + vbQuestion + vbDefaultButton1, "Sort Worksheets")
   For i = 1 To Sheets.Count
      For j = 1 To Sheets.Count - 1
' If the answer is Yes, then sort in ascending order.
         If iAnswer = vbYes Then
            If UCase$(Sheets(j).Name) > UCase$(Sheets(j + 1).Name) Then
               Sheets(j).Move After:=Sheets(j + 1)
            End If
' If the answer is No, then sort in descending order.
         ElseIf iAnswer = vbNo Then
            If UCase$(Sheets(j).Name) < UCase$(Sheets(j + 1).Name) Then
               Sheets(j).Move After:=Sheets(j + 1)
            End If
         End If
      Next j
   Next i
End Sub
Can anyone help me with this please.

I am an elementary school teacher.

Our students' reading progress is tracked by Fountas & Pinnell book levels. These levels proceed from A (easiest) to Z (most challenging).

I am trying to create a way of displaying student progress (e.g. comparing 25 students in one class) using a graph that could display the students' book levels.

I would like to use a bar graph that would show a bar for each student extending to the letter representing their book level. For example, I would like student names on a y axis and the a to z book levels on the x axis.

I am encountering difficulty because the letters are not numbers and I am interested in finding a way to have Excel create a alphabet based scale rather than number based scale.

I tried looking at Excel help and did a bunch of googling with no success, so I would be very appreciative of any help!


Is there a way to lock the rows so I can rearrange words from A to Z?


Hi all,

The user in user form’s textbox should enter Drive Letter (A to Z only, nothing else). How we can do this.

Thank you in advance.

New Free software and games download (A to Z)

If we are to have real peace, we must begin with the children.
Free software and new games download.... Everthing is available here.....
Just click......

Sub testrow()
Dim c As Range, i As Integer 'I INTEGER???
Dim ReplaceFrom As String
Dim ReplaceTo As String

ReplaceFrom = InputBox("Letter to be replaced - Same case")
ReplaceTo = InputBox("Letter to be replaced to- Same case:")

For Each c In Selection.SpecialCells(xlCellTypeFormulas)
With c
For i = A To Z ????????
.Formula = Replace(.Formula, i & ReplaceFrom, i &
Next i

.Formula = Replace(.Formula, ReplaceFrom & "$", ReplaceTo &
.Formula = Replace(.Formula, "(" & ReplaceFrom, "(" &
End With
Next c
End Sub

FROM A-Z (ReplaceFrom & ReplaceTo being row numbers)


Hi All,

If we want to assign cell values with number we can use a for loop, for e.g.-

For i = 1 to

Cells(1, 1).value = i

Similarly, do we have any such thing to populate alphabets..

like For i = A to Z or something like that..

Greetings to all,

My aim is to sort into A-Z order a range of worksheet tabs,
I have a tab named 'A' and a tab named 'Z' and various tabs in between, that
I would like to automatically sort A-Z, I also have some tabs prior to tab
'A' and after tab 'Z' that should remain unsorted and as they are.

is it possible?

Repects to all.

Hi, I have a spreadsheet with a number of entries over 25 columns on sheet1
that are totalled in row 30 (cells A30 to Y30). On sheet2 I have a summary
for each category that is linked to the sums on sheet1. I would like the
sheet2 summary to automatically sort every time I update the numbers on
sheet1. Could anyone help please.

hi - i need help sorting farm data from a master sheet to another sheet.

on the primary page i will be inputting information ordered by date. it will include date, bed #, type of plant, # plants, etc.
i'd like this information to be automatically sorted by bed # onto another sheet. is there a way to do this and to automatically update?

there are about 25 beds total- perhaps it would it make most sense to have a different sheet for each bed #. the most important thing is that the tables automatically update when information is added to the mastersheet.

please help!

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.
Appreciate all help.

Can anyone tell me how to sort a range of cells so when the values are automatically generated with in the column of cells they will automatically sort themselves numerically? I have attached an example of what i am trying to do.
Thanks for all your help ! !

Hi to everyone

Hopefully someone can help! I have a spreadsheet where users input a letter
from a to z into a textbox. How can I make Excel convert this letter to a
capital letter automatically, in case someone enters it as a lowercase
letter? Dont know if this can be done, but hoping it can!! I know about the
UPPER function, but that is not quite what I need as that function enters the
letter as uppercase into another textbox. I need it as uppercase in the
textbox in which it is entered.

Many thanks

I have a worksheet that has data in it in columns a:i. Rows 1-6 is the title of the worksheet. Row 7 is the header for columns a:i. I would like to have the range of data sorted by column G. This column is the due date for a job. Is there any way that I could have the range automatically sorted by column G when a new row is added with a new due date? I would like the dates to be in order of the soonest due. I.E. if todays date is 4/1/2011. The first would be due 4/3/2011, then 4/8/2011, then 4/11/2011 and so on.

r = Range("c65536").End(xlUp).Row 
Range("a5:G" & r).Select 
Selection.Sort Key1:=Range("G5"), Order1:=xlAscending, Key2:=Range("F5") _ 
, Order2:=xlAscending, Key3:=Range("C5"), Order3:=xlAscending, Header:= _ 
xlNo, OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _ 
DataOption1:=xlSortNormal, DataOption2:=xlSortNormal, DataOption3:= _ 
Rows("4:" & r).Select 
For i = 5 To r 
    If i Mod 2 = 0 Then 
        Selection.Interior.ColorIndex = xlNone 
        Selection.Interior.ColorIndex = 36 
    End If 
Application.Calculation = xlCalculationAutomat 

If you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines
this sorts range from A to G and set color to each second row how can I include S column in this range
I mean that cells in column S are moved with cells from columns A to G
Any help would be apreciated

Hi there,

I have a small league table which updates using data from another work sheet.
I'd like the the table to automatically sort, in ascending order, when the data is changed on said work sheet.
Can this be done using a formula, or does it have to be macros?

I only know the very basics of excel, so my apologies!

I have attacthed the workbook in question!


What formula would I put in a range of cells that would automaticly sort that range of cells in order of value when numbers are added to the cells.

Is there a way to set a condition to automatically re-sort data as it changes
on a table?


I have 3 column:
A) Sales agents
B) Items Sold
C) Total Sales in Dollars

the data is being imported into those colums from various sites and
I'd like the 3 colums to automatically sort Hight to Low (Z toA) by Dollar
Amount (column C).

Any suggestions?

I have a range of indeterminate length consisting of 3 columns (name, team,
goals - it's a top-scorer list.)

What I want to do is have Excel automatically sort the full range based on
the Goals column whenever data is added to the list (ie new scorer entered)
or edited (ie existing scorer gets another goal.) to keep the list always in
order of most goals scored.

Anyone got any ideas?

Hello there

I'm wondering if anyone can help me with this. I've got quite a bit of Excel and programming experience, but this is an issue I can't seem to figure out.

I have to keep records of what invoices are sent to particular people and when they are received back from them. There will be one person processing the sending of the invoices and another person will be processing when the invoices are received back. To avoid having one workbook open by two people, I have decided to split the table of data into two workbooks.

As such:
I have two workbooks. Workbook one we shall call the 'Sending' workbook and workbook two the 'Receiving' workbook.

Contains a table with headings relating to information about the invoices (irrelevant in this question), and a 'Date sent' heading. As well as a 'Date Received back' heading which is linked from the receiving workbook (we'll get to this one shortly)

Contains a table where headings relating to invoice information and the 'Date Sent' heading are linked from the sending workbook, so as all the data entered into the sending workbook is displayed in the receiving workbook (the user cannot edit this data in the receiving workbook). The receiving workbook also contains the 'Date received back' heading, which the user can input data into. This heading is also linked back to the sending workbook so that data entered into the receiving workbook is displayed in the sending workbook.

This sort of almost creates a circle. 'Sending' creating the record and 'Receiving' adding to it.

I have set this up and it works. BUT my problem is, is if you sort the data in one workbook (such as sorting A to Z), it screws things up. If you put a date received onto one invoice and then do some kind of data sort, that date received is now applied to a different invoice, like as if they are two separate tables and I am only sorting one. Also, sorting the table in one workbook automatically sorts it in the other workbook, which is also a problem.

So I want to know if I can somehow get these tables to sort correctly. Or, if there is some kind of way to have a workbook open by multiple people, then that solution would be even better.

I hope this hasn't been too confusing :-P Any help would be great! :-D

Ok, so I have data that is all dates in column A that pulls from another source:

I used this formula in column B to suppress errors:
Therefore, This formula shows a blank cell if there is an error.

However, I noticed when I need to sort the data in column B using a filter, it only allows me to sort A to Z and not from "Oldest to Newest". Ive highlighted all of column B, and made sure the formatting of the cells is set to Date.

In Column C, I put the formula =ISTEXT(B1) and so forth, and it shows False for cells that are truly blank, but True for blank cells created from the formula that used "", even though I have that cell set as a Date. If I use nothing in the ISERROR formula instead of blank, I get the date of 1/0/1900 which I would like to avoid as when sorting it puts all these dates to the top.

Is there another method to have a blank and override so Excel 2007 sees it as date and not text? Thanks for the help.

Oh, and another thing to note is that in column B, when I have 10 dates, I can have 15 more cells blank from the iserror fomula, but at number 16 of blank results it will change the ability from oldest to newest sorting to A to Z.

I have a dorm roster on one sheet and the other sheet is an Alpha Roster. I want it to automatically sort alphabetically (column B) . Any time I change the roster, the Alpha Roster sheet doesn't automatically sort, I have to hilight and re-sort it again.

I updated the file, there are 4 tabs at the bottom. 1st Floor, 2nd Floor, and 3rd Floor. I want to have all the names, room numbers, and phases (ph) in alphabetical order on the Alpha roster tab. And when ever I make changes to one of the Floors, it will automatically update it the Alpha Roster.

Is there a way of coding a selction of sheets between two points? (lets call them A and Z)

For example, I have used the formula =sum(A:Z!a1) to add all values between sheets A and Z

I now want a macro to clear certain cell values on all sheets between A and Z

Being totally useless, I thought simply recording a macro where I hit A hold SHIFT and hit Z (so all sheets were selected) then deleting the cells i want clearing would do the job, but on looking at what was recorded, the macro names all the sheets between A and Z.

Normally this wouldnt be a problem, but the sheets names between A and Z change so the macro would only be of any use while the names remains static...

anyone think of a way around this...?

As usual, thanks for any help in advance and I bow you your superior uberness in all things excel! :D

No luck finding an answer? You could always try Google.