I have a spreadsheet with close to two dozen buttons that seem to relocate from time to time
I am wondering if I remove the buttons can a index for rows be pulled for the sheet
replace the buttons in a particular cell C7 C14 c18 for example and then hide and unhide rows based on the drop down list in those cells
this might enable me to setup if and or if else statements in a single function based on the particular cell and its value to hide and unhide these rows and get rid of my button problem at the same time
thanks for any insight
Bookmarks