I have many worksheets that include a table that has headings along row 10, data beginning with row 11, ending at row 1010. I often sort Column D (the Date Column) in ascending order. How can I create a macro that will sort multiple sheets at once? I'd like to be able to specify, for example, IF X7 contains "sort", then running the macro would sort the dates on all those sheets.
Bookmarks