linking sheets

It's working here. You might try uninstalling it. In Finder hold down the option key and Go > Library in the menu. Delete it from the Services folder there. Then download again from the link in the May 30, 2017 message.

SG

No it's working under Numbers 4 here with Region set to US.. I assume you have the document open before trying to run the service. Perhaps your Mac is set to a different Region and that's somehow causing a problem?

SG

so weird. closed everything. checked region settings was set to US and english, the only thing i had installed was additional German Keyboard. Deleted that. restarted Numbers. Now the script works.

Thanks for the help. Awesome script. Helps tremendously.

Thanks again

There is no "jump to" type link in Numbers. If you name your Sheets and Tables in a recognizable way, you can use the tabs to efficiently navigate to other sheets and tables. The Sheet Tab submenu has a list of tables on that sheet, and they act like links.

Jerry

If you are talking about sheets within the same document, you can have something like this pop up whenever you hit a keyboard shortcut (in my case shift-command-j):

This is done via a Jump to Sheet Automator Service (Dropbox download). To install just doubleclick the .workflow package and (if needed) click 'Download Anyway' in System Preferences > Privacy & Security.

This will cause a new item to appear in your Numbers > Services menu. Then, if you want a keyboard shortcut, go here in System Preferences and add one:

You can rename or remove the service by holding down the option key in Finder and choosing Go > Library > Services. You can also view the AppleScript contaned within the service by opening the .workflow package in Automator.

This particular service jumps to the first cell of the first table of the sheet you choose from an automatically generated list of all sheets in the current document. Using simple AppleScripts it is also quite easy to "jump" to any cell in the current document, to cells in other Numbers documents, or even to non-Numbers files on your Mac.

SG

This was great! Thank you very much!

Glad to hear you are finding it useful!

SG

hey there

no matter what i do i can not get the key board short cut to work any advice? thanks

My advice would be to be more specific about what you have tried. Make sure the shortcut you have chosen isn't "already taken."

SG

i have tried different shortcuts indulging the one that you have listed above and currently i have it set at command j. i see the jump to sheet in my number services but when i hit the shortcut it dose not do any thing.

Perhaps you have never used Automator on that machine before? You could double-check to make sure that 'Automator.app' is enabled (the check mark is checked) at System Preferences > Security & Privacy > Privacy > Accessibility.

SG

Numbers 4.0.5 - Worked like a charm, massive thanks!

Had a sheet with several tables laid alphabetically from left to right and really needed a quick way to navigate over 40 tables that are each fairly wide. Originally had no problems as I could click on the grouping Sheet's name and the drop down menu would appear allowing me to select the Table name I needed from the list, then jumping straight to it.

HOWEVER printing was a nightmare and on reading lots of different forum posts, it seems there's a small bug that when attempting to line the tables up incrementally, they would accumulate slight and inconsistent point/pixel additions in the Print Preview field. This would mean columns do not appear as their containing table overruns into another one. This is DESPITE all the tables being at set intervals, infuriating. There's also a small issue that over a certain x position, you can no longer manually enter a number to set the position of a table. Again crazy. Well done SG, here's hoping this is in the next Numbers release!

Thanks for the positive feedback on the Automator Service. If you have features you want to see in future release recommend communicating with Apple via Numbers > Provide Numbers Feedback in your menu.

SG

Done on all accounts, thanks again SG.

Hi SG

Exactly what I need. Unfortunately the Dropbox link no longer works. It'd be great if you could provide another link to download this awesome script.

Cheers!