I am having a tough time with a simple formatting macro. For sheets 1 and 2 in my workbook, I need a macro that will move the following dates to the bottom of the data, and highlight the entire row in which the dates appear in yellow.
The dates are:
7/1/1977 (appears in sheet at Jul-77)
5/1/1955 (appears in sheet as May-55)
9/1/1999 (appears in sheer as Sep-99)
Thanks for any help!
The dates are:
7/1/1977 (appears in sheet at Jul-77)
5/1/1955 (appears in sheet as May-55)
9/1/1999 (appears in sheer as Sep-99)
Thanks for any help!