Become a MacRumors Supporter for $50/year with no ads, ability to filter front page stories, and private forums.

SteveSea

macrumors newbie
Original poster
Mar 28, 2018
1
0
England
Hi

Can someone help me with an Apple Script problem?

My background is Excel on a PC where I have been using Visual Basic. I want to do away with my PC and need to set up the attached spreadsheet in Numbers using Apple Script?

When a name is typed in the column F the row is copied to the next row in the matching worksheet giving me a record of all the transactions for that name. eg Delta row is copied to Delta sheet and Alpha line is copied to Alpha sheet.

I would appreciate any help with the script for this.

Regards
Daybook Example.jpeg
 
Register on MacRumors! This sidebar will go away, and you'll see fewer ads.