spread sheet use of Look function to automate collection of Grid refs from Find sheet.
I've just completed my initial, modest contribution of 10 routes.
I worked by pasting start,finish,name to a notefile, where I later also paste the route URL.
(pasting the URL saved me from an occurrence of the Route not found problem reported by others)
If there will be a furture substantial body of new routes, some streamlining could be achieved with automatic lookup of the grid refs from the Find sheet, using the Lookup or possibly Vlookup function.
(experiments hampered by edit Protection, live working, and limited knowledge of googlesheets).
Please sign in to leave a comment.