Macros to Applescript help please

[juliebenn]

I have a macbook pro and i am trying to put a macro onto a worksheet in excel mac 2008. I know it has to be changed to apple script can anyone please help me??

What i want is when i type PAID into a row in a certain column it will then transfer this row onto another sheet for me.

ie SHEET NAME = JOBS DONE


A B C D E
1
2 PAID (this then goes onto another sheet named PAID JOBS)
3
4

I WOULD REALLY APPERCIATE ANY HELP

Many Thanks

 

[BlueRevolution]

I'm not familiar with Excel, but I don't see why you should have to use AppleScript for this, or even macros. Surely Excel has some way to reference data found on other sheets...