Originally Posted by innerspaceboy

Today marked a milestone accomplishment which brought me great joy.

I'd been working since last March to refine my lists of ~26,000 media highlights from my library into a single, fast, and intuitive interface. Today that vision has been realized!

By creating over 200 named ranges, employing a few Google Scripts, indirect references, and conditional dynamic dependent drop-down fields, I've consolidated hundreds of sheets of data to a single, intuitive, and instantly-responsive page.

If anyone is interested there are project details and a link to the project itself in my member journal.

Originally Posted by J.R.R. Tolkien

There is only one bright spot and that is the growing habit of disgruntled men of dynamiting factories and power-stations; I hope that, encouraged now as ‘patriotism’, may remain a habit! But it won’t do any good, if it is not universal.