Excel Question
Excel Question
- Subject: Excel Question
- From: Bill Guion <email@hidden>
- Date: Sat, 21 Jul 2012 12:29:57 -0400
I have an Excel spreadsheet that I use to keep track of medical expenses, insurance payments, my payments, etc. On some rows, in the ith column, I enter this formula: =D9-G9-H9 (if the entry happens to be in row 9). What I normally do is move the active cell to another row, copy the formula, move the active cell back, and paste the formula.
It would be nice to activate the desired cell and enter a key combination which would run an Applescript. The Applescript would determine which row is active and construct the formula (let x be the active row): =Dx-Gx-Hx, then paste the formula in the active cell.
Can someone point me in the right direction for this?
-----===== Bill =====-----
--
If God wanted me to touch my toes, he would have put them on my knees.
_______________________________________________
Do not post admin requests to the list. They will be ignored.
AppleScript-Users mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
Archives: http://lists.apple.com/archives/applescript-users
This email sent to email@hidden