ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Using a macro to sort your data in alphabetical order? (https://www.excelbanter.com/excel-discussion-misc-queries/21974-using-macro-sort-your-data-alphabetical-order.html)

Carrie

Using a macro to sort your data in alphabetical order?
 
I want to add information to a worksheet and then sort the data into
alphabetical order all using a macro.

Can not seem to be able to get this function to work.

Can it be done? If so how?

Fredrik Wahlgren


"Carrie" wrote in message
...
I want to add information to a worksheet and then sort the data into
alphabetical order all using a macro.

Can not seem to be able to get this function to work.

Can it be done? If so how?


Select the column(s) where your data is and use Data Sort. A wizard will
appear.

Lets say you have a list of mnames. If you have Name in column A and Tel# in
column B, you must select both columns before you do the sort so that name
and phone# match after the sort is done.

/Fredrik




All times are GMT +1. The time now is 07:46 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com