Home |
Search |
Today's Posts |
#2
![]() |
|||
|
|||
![]() "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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
sort data without formulas in other cells changing? | Excel Discussion (Misc queries) | |||
Extract specific data into its own workbook via macro? | Excel Discussion (Misc queries) | |||
help with macro to save repeating data entry | Excel Discussion (Misc queries) | |||
Keeping Row 1 at the top during a Data Sort... | Excel Worksheet Functions | |||
cells lose relativity to other WorkSheets after data sort? | Excel Worksheet Functions |