Hello all,
I have a sheet filled with various quotes that I enjoy/relate to and like to see occasionally as a reminder. Let's call this sheet "Quotes". Each quote is in an individual cell.
I have another sheet that could be considered a "Menu" page from where I can select the other pages I would like to see/work on.
My end goal is to figure out a way to populate a single cell on the "Menu" page with a quote from the "Quotes" sheet, but that would select & display a new quote on a daily basis.
Is there a formula that would select one quote amongst a whole range of values and display it on another sheet?
Thanks for any suggestions/help you have!
I have a sheet filled with various quotes that I enjoy/relate to and like to see occasionally as a reminder. Let's call this sheet "Quotes". Each quote is in an individual cell.
I have another sheet that could be considered a "Menu" page from where I can select the other pages I would like to see/work on.
My end goal is to figure out a way to populate a single cell on the "Menu" page with a quote from the "Quotes" sheet, but that would select & display a new quote on a daily basis.
Is there a formula that would select one quote amongst a whole range of values and display it on another sheet?
Thanks for any suggestions/help you have!