I am new to Mac, I have only had mine 2 weeks.
On my PC I used Microsoft Office but in a bid to steer clear of Microsoft I got iWork with my Mac.
My question is to do with automating tasks in Numbers. I have several Excel spreadsheets to do with various bank / credit card accounts. As I made a transaction details are entered into the spreadsheet, when I get a statement I check the items off on the spreadsheet. I then had a macro which checked the balance was correct and removed checked off items from my spreadsheet, and then moved up, as appropriate, the outstanding items.
is there a way i can achieve this sort of thing with Numbers? If so could somebody please point me to a tutorial or guide where I can learn how to do it