Dear All
I come across a excel template which created few years ago, the person who created it has left the job. the template has a drop down list, you can select either subscription or purchase. the magic to me is, if you select purchase, some other cells text became invisible, the cells are still there, just you see blank cells. but if you click the cell, you will see the text in the formula bar. if you select subscription, you will see the whole set of cell text appeared again. I try to work out how it has been created for days and googles all possible solutions, no answer at all.
it's not a dependent drop down list. I also review if there is formula on those cells, nothing, just plain text
would be great if any of you contribute your thoughts as some of the cells does not work properly, i.e. when you select purchase, cells still visible. I need to amend the template and share it with other shortly.
Much appreciated your ideas.
Thanks
I come across a excel template which created few years ago, the person who created it has left the job. the template has a drop down list, you can select either subscription or purchase. the magic to me is, if you select purchase, some other cells text became invisible, the cells are still there, just you see blank cells. but if you click the cell, you will see the text in the formula bar. if you select subscription, you will see the whole set of cell text appeared again. I try to work out how it has been created for days and googles all possible solutions, no answer at all.
it's not a dependent drop down list. I also review if there is formula on those cells, nothing, just plain text
would be great if any of you contribute your thoughts as some of the cells does not work properly, i.e. when you select purchase, cells still visible. I need to amend the template and share it with other shortly.
Much appreciated your ideas.
Thanks