I have a cell that is auto populated from another worksheet. It is a cell
that contains what can be quite a long paragraph of text which can contain
multiple lines that have been input using (ALT - return).

The cell has been set as a merged cell of 10 rows (to allow for space if the
source data is across multiple lines).
I want this cell to be able to cope with whatever size of data the source
data contains). At the moment I have just left 10 lines available, but if
the source data cell contains information that is over 10 lines then this
will be cut off from the destination cell.

I want a way of handling this so in the cases where there is more then 10
lines, the destination cell pushes down all the rows below it to accommodate
for the extra space requirements.

In an ideal world, I could just use both shrink to fit and Wrap text,
because then if it is over 10 lines, the fonts just reduce in size to allow
for more, but if I turn this on, I have to turn off wrap text, which is
necessary because the contents is in a mutli line cell.

I do hope this makes sense and I look forward to any suggestions how one can
deal with this.

Kind regards

Dave