Script Editor

One thing you can try is to temporarily put in the middle of the script the line

return last word of oldName

in the script to see what the result is,

and then change it to

return newMonth

to see what it is.

If the month is always a three character abbreviation at the end of each table name then you can simplify the script to something like this:

(be sure to copy the whole thing including parts that are hidden to the right)

set newMonthName to (choose from list {"Jan", "Feb", "Mar", "Apr", "May", "Jun", "Jul", "Sep", "Oct", "Nov", "Dec"}) as text

tell front document of application "Numbers"
	repeat with s in sheets
		tell s
			set oldTableName to name of table 1
			set name of table 1 to text 1 thru -4 of oldTableName & newMonthName
		end tell
	end repeat
end tell

SG

I typed in most of your script and it worked fine for me.

I am trying to figure out what result you are getting. You mentioned "Finance Statement 2025/- Oct" as one bad result, "Finance Statement 2025/26 - ??" as another bad result, and "Finance Statement 2024/25 - Nov" as being okay. If these are all for the same table, I don't understand how the years changed or why the first one lost the second year (presumable "26") and the space before the "-" or where the question marks came from in the second one.

What was the original table name? I assume it ended in "Sep" but I don't want to be assuming anything when things are not making sense.

Your steps say you "[place the] cursor next to where I wish to change the month". Why do you do that? All you need to do is have the document open and up front. Your script changes the title of the first-created table of each sheet.

PaulSG wrote:

Many thanks Badunit.

SGill - dumb quest possibly but can I copy and paste into Script Editor or better to type exactly as shown (inc colours)?

If you carefully select all of the script including what's scrolled out of sight then you should be able to just copy-paste into Script Editor. No need to retype. Script Editor will color as it sees fit.

I usually File > New in Script Editor and paste a script in that document, then run that new one on a duplicate of my document until I'm sure it's doing what it's supposed to.

That way, the originals are still there if something goes wrong.

SG

I don't know why your script is failing but, regardless, I'd go with SGIII's suggestion. It is much more straightforward.