I've attached an .XLSM file that has a table titled "Lineup," which lists the opening day lineup for the Boston RedSox (See below):
BSox.jpg
Using the Worksheet Events Private Macros, I attempted to have the Lineup table automatically resort by Batting Order (Column A) and to time-stamp Date Modified (Column E) in the row(s) where the change(s) were made. Changes may come from altering any of the Columns, such as changes in Stats (Column D), or simply by adding new rows to the Lineup table:
It would be an added bonus to add the username of the person who made the changes/additions to Username Column F - in the appropriate row. The code I have so far is not working. I would also like to set a dynamic range, since the Lineup table will most likely increase in rows and columns. This dynamic range should also adjust for the time-stamp and username if those columns are shifted from their current positions in Columns E and F, respectively. I've searched and tried and numerous solutions, but can't get any to work, or one time it worked initially, and then stopped working. I have no idea why. I saved the workbook as an macro-enabled file, and I've also allowed permission for macros to run on my computer (it is in a work office environment), and I "believe" my Application.Enabled = True instructions are appropriately set. Any help would be much appreciated.
Bookmarks