Hello:
I have a rather large Excel document with several sheets that is updated on a daily basis. I have found myself trying to figure out how to get a section of the applescript to perform the following:
example of worksheet:
A B C D E F
123| 12/27/2011 | 10 | 21 | 15 | 22 | 14 |
125| 12/29/2011 | 21 | 24 | 13 | 31 | 12 |
126| 12/30/2011 | 22 | 21 | 14 | 22 | 13 |
127| 12/31/2011 | 13 | 22 | 15 | 21 | 15 |
I need to get the AppleScript to find today’s date (12/31/2011) on column A and then select the entire row (127)
I have contemplated several formulas, but I am missing something… I am unsure of what it is…
Any help will be appreciated!!
HT