I have created a spreadsheet where in cell A3 is a dropdown list and when a selection is made from the dropdown list this auto populates a paragraph of text in cell D4. My problem is that the text populated in cell D4 needs to editable?When I try to edit the text the formula is show and the text disappears??
Anybody know if this is possible? If yes then how would I go about it please?
Many Thanks,
Yidolee.
Bookmarks