putting a macro in excel 2008 MAC

[juliebenn]

Hi I've just got a macbook and am transferring an excel sheet from pc to mac using office mac 2008. It won't recognise a macro i had in the sheet - can anyone help me to put this macro in??

this is what i need

in workbook named jobs done
if column J says PAID then move the row to worksheet named jobs paid ie=

A B C D E F G H I J
1 PAID (move to sheet jobs paid)
2
3
4
5

[Leith Ross]

Hello juliebenn,

You should include the macro code in your post. The are more than a few differences between the Mac version of Excel and the PC version. Without more information, we can't answer your question.

[juliebenn]

Hi thanks for your reply

How would i find out the macro code??

thanks for your help

julie

[Leith Ross]

Hello juliebenn,

You should post the Excel workbook (PC version) here on the forum for review.

[romperstomper]

FYI, Office 2008 does not accept macros at all. You would need to try and convert it to Applescript from VBA.

[juliebenn]

thanks for your reply - would you know how i might do this??

[romperstomper]

I don't know any Applescript at all, I'm afraid (I have Excel 2004 too, so I just use that for macros instead of 2008)
You could just use an Autofilter and copy and paste?

[juliebenn]

sorry for being so thick but how would i do this?

[romperstomper]

Sorry for the delay - wanted to get back to my Mac and double-check the commands. It's actually very similar to the PC:
Select your data.
Choose Data-Filter-Autofilter from the menu.
Select 'Paid' as the filter for column J.
Select the data and either Cmd+C or Edit-Copy (this will only select the visible rows)
Switch to the other sheet and paste wherever required.