hello guy's i need to fill a "formula" from cell F2 to unknow cell
for example i have database in column from A to E sometimes there are about 29 row's but another times there are about 300 row's that's why i don't know how many cell i have to fill
the applescript can count the cell form column E are full and put my range fromF2 to "the count" and fill my formula??
i need help
OS X Mountain Lion (10.8.5)
I don't know why you need AppleScript for this. A simple cell formula can be used to detect how many rows contain data.
For example, set cell F2 to:
=IF(ISBLANK(E2),"",123)
and copy it down the column. This will check the preceding cell. If it is empty ( ISBLANK() ) it leaves the cell empty, otherwise it fills in the value '123' (obviously, you change '123' to whatever value/calculation you want the F column to display.
Like I said, it can be done in AppleScript, so let me know if this isn't enough for you.
AppleScript - Excel Fill some row's
