Hi.
First post in this great site. Already found loads of info but although I searched could not find the answer to my problem.
Here goes.
I have a workbook that holds issues encountered during a working week. There are 5 days with a tab for each day. Issues encountered on each day are entered in the respective day/tab. The worksheets are set to be printed on A4 so they cannot expand width ways so a number of cells are merged and the text is set to wrap. This works well in the input sheet but I want to create a summary sheet that shows the issues of all days on one. I have created the sheet by stating that the merged cells on the summary sheet equal the merged on the feeding sheet. All good so far.
What I cannot do is get the summary cells to grow if there is more than 1 line of text being imported, I have set the summary merged cells recieving the info to wrap but they don't. I guess it's because they are in fact only holding a formula e.g.
='Mon-Fri mornings'!B25:Q25
='Mon-Fri mornings'!B26:Q26
and so on so do not need to wrap, is this correct ?
What I would really like to achieve is that if there is data imported the summary cells auto size to accomodate that data , if there is no data the summary are hidden. That way I would not have a sheet with empty cells running down when I print the sheet.

Eagerly awaiting response
Thanks in advance
PB