[MAC] Excel 2008 insert row using applescript

LawrenceIES

New Member
Joined
Dec 13, 2010
Messages
9
Hi all,

this is the file I'm talking about:
http://rapidshare.com/files/436674965/TStest.xlsx
I'm trying to make a new timesheet for my company; I had made one with a nice macro in excel 2011 but since evrybody at the office uses 2008 so I wasted my time :)

What I want to do is have a function that allows staff to easily insert a row in a certain "category" (let's say in the first one; external projects) while automatically adding the same "sum" function at the end as the other rows.

In excel 2011 I had made a macro assigned to a little picture in the top right corner with the instruction "click this pic to insert a row below the selected cell"

Thing is, we all know its easy to just insert a row and drag the formula down but some people here at the office don't really "get it" or are very old etc. and it would take me forever to go through all the timesheets to check whether data was put in correctly and all formulas add up.

I have been googling for half a day but cannot really find anything and have no experience whatsoever with Applescript, and cannot convince management to switch to 2011.

Great thanks to anybody that can be of assistance before the end of the year
 

Forum statistics

Threads
1,085,855
Messages
5,386,376
Members
401,996
Latest member
mg07p929

Some videos you may like

This Week's Hot Topics

Top