Sheets Rows Columns Functions from a drop down selection

[kwd53]

I got tired of Floating buttons randomly moving around my google sheets so I created this spreadsheet to allow others to see that it is possible to get rid of all of your buttons once and for all.

This spread sheet has two hidden sheets #2 and #3 the options page has named ranges and Data Validation list name to use in a drop down from a range

Sheet1 has show and hide sheet selection you choose sheet2 it opens sheet2 and closes sheet1. sheet2 has the same options to jump to each sheet if you choose your current sheet it will give you a message and try again

sheet1 also has a show hide rows drop down a column show hide and lastly there is a run function from a drop down

I am sure there is a lot more I can do with these drop downs I have not even thought of yet but thought I would share this with everyone

There link below will take you to the sheet and you will need to make a copy to view how this is done I tired to put in some easy to follow pointers




docs.google.com/spreadsheets/d/1ZzAa86O5Nizb0oIyp6SQ0WjO8Sb7lTjA9f8-eqgtQ-o/edit?usp=sharing

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[janmorris]

Interesting creation. Thank you for sharing.