Hello,
Setup:
Five sheets
Sheet one is the Executive summary sheet.
I have the other four sheets feeding information to the Executive sheet. I have set the Text wrap on the cells in question that are set to populate the information from the other cells on the four other sheets.
However, the cell is not expanding on the Executive sheet. I am having to manually expand the cell. It works if I manually type in something, but not when it is coming from another sheet via a reference.
So, is there a way to have the cell automatically adjust the height based on the reference content?
Bookmarks