Applescripting automation in Numbers
Hi All,
I might have bitten over more that I can chew here.
I am trying to automate some tasks in numbers, but am having some difficulties writing the script.
I am trying to achieve some re-arranging of data with scripting to make things faster.
- in active sheet, table 1, Sort all cells based upon column 1 - ascending
- Move column position from 6 —> 2, or just create a new column (after column 1) and copy/paste all cells from column 6, into the new column 2
- Delete column 3, 4, 5 ,6
- Select and copy all cells in all columns into clipboard
- Switch active sheet to “budget”, and table “data”
- Go to end of table “data”
- Insert extra row at the bottom
- Paste clipboard data into new row, table “data” - using “paste and match style”
Can anyone help me with this?
Best...Jan