I have posted a question recently but it had no replies… I will try and explain this differently and in hopes for some help.
I have an excel file which contains several sheets, in which I am documenting daily activities.
I am trying to get Applescript to help me automate this process.
I found a way to find the date and select the correct cell with the date, but now I need that row to be selected, is there a way to setup the row number as a variable and how can I get the value of the selected row to the variable?
A B C D E F
123| 1/1/2012 | 10 | 21 | 15 | 22 | 14 |
125| 1/2/2012 | 21 | 24 | 13 | 31 | 12 |
126| 1/3/2012 | 22 | 21 | 14 | 22 | 13 |
127| 1/4/2012 | 13 | 22 | 15 | 21 | 15 |
Lets say, that in this example the date is 1/3/2011, which chooses cell “A126” how can I make excel now select the entire row 126?
any help will be appreciated!