Hi – On a MSExcel2007 spreadsheet, I’m trying to sort on a column that lists by “city” (e.g., Palo Alto, Menlo Park) and I want all the other data to “follow” as well. Please let me know how to do it. Thank you kindly.
Do it from the Data tab. If you chose sort there it should prompt you with the column names. If it doesn't then you need to select the entire table before you hit the Sort button.
Hope this helps,
Microsoft Access MVP 2007
Author: Microsoft Office Access 2007 VBA