Can one use a macro to collate worksheets in a workbook based on the contents of a specific cell? For the workbook I have in mind, cell B42 in each worksheet contains the name of a person, so I would like to collate the worksheets alphabetically by their names. Thanks for any help you can offer!
Bookmarks