Tough one: office 2008 MAC

[LawrenceIES]

Dear all,

I have an issue that I cannot use Macros for, because we have office 2008 for mac and won't be switching to 2011 anytime soon.

In our timesheets, we have a row for each differnt project/category and a sum for the row at the end.

Problem is this: I want everyone to be able to insert a row if they feel they need to create a new category, but I fear not everyone will be able to fix the sum at the end themselves, and I do not feel like going through all these timesheets to check whether it still totals up.

I had written a nice macro to do this in office 2011 for mac, a button that inserted a row below the selcted cell adn that copied the sum formula. But, as stated above, we will keep on using office 2008 so a macro is out of the question.

Can anybody please help me or at least point me in the right direction? I've heard applescript might be an option but i cannot seem to find enough documentation or examples on the matter.
I have posted this question before but have gotten zero replies so any help or at least a reply is greatly appreciated.

Best,

Lawrence

 

[RoryA]

I don't know of a workaround for that, I'm afraid.

 

[LawrenceIES]

Thank you all for your help.
see http://rapidshare.com/files/438741992/TStestList5.xlsx for the result.

Another follow-up question though: one of my bosses insist on also having monthly totals (don't see why but hey )

I would like to create these on a different sheet, but my question is: is there an easy way of doing this without having to change the sums 12 times? I reckon I can define each of the months with a name or something and then tell each of the 12 columns to just total up "Jan", "Feb" etc... only I dont know how

Don't know if any of this makes sense, I'm sure if you have a peak at the file you'll get it though.As usual, any pointers very much appreciated.