AppleScript in Numbers

I am a TOTAL beginner here so I’m hoping someone can help. I have changed up some script I found on the internet for Google Sheets documents before to get it to do what I needed but never on a mac in Numbers. I am trying to have Numbers automatically copy and paste rows from one sheet to another when a particular column has a specific number in it. For example: I have a list of names that I will assign a table number to. My hopes are that once I assign that person a table number I can have Numbers automatically copy and paste that persons row of information onto that table numbers own sheet as a roster. So I would have a master list of everyones name that would essentially create a list of the people at each table on separate sheets. Any help is greatly appreciated!

Posted on Oct 31, 2019 10:36 AM

Reply
1 reply

Nov 1, 2019 7:26 AM in response to Lacey428

What you describe is possible with AppleScript but a fair amount of trouble. Why wouldn't you just use the built-in 'Categories' function in Numbers? (Add Category in the Organize menu). If you have a column for table number, then with just a click or two Numbers can display your data grouped by table number.


BTW, "sheets" in Numbers are a blank canvas on which you place tables, charts and other objects. Unlike in Excel sheets themselves don't have cells. Tables do.


SG

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

AppleScript in Numbers

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.