autofit cell height for merged cells

[elsuji]

Dear Team,

I have a problem with auto fit height with merged cell.

I am having sheets Data, Sheet3. Sheet3.a. In data sheet i merged C5&D5 cells and entering address and the same was copied to Sheet3 & Sheet3.a with range of B8:F9 which is merged.

When i am entering the address in Data C5&D5 the entire row should auto fit and also Sheet3 & Sheet3.a also to be auto fit automatically.

The sample file is attached here.

Can any one help me for this

[paulked]

It's been said sooooo many times in this and other forums - AVOID MERGED CELLS

[elsuji]

If i remove merging the alignment get problem. Please help me with merged cell

[paulked]

Design is key... fail to prepare, prepare to fail.

When designing any sheet for viewing/presentation I tend to avoid using cells as the holder of info as much as possible (unless, for example, a table is needed). Text boxes, graphs, shapes etc are the things which can be non-functional but really useful for presenting the data to the user in the form of a dashboard. Do the calculations, data storage etc on other sheets but, especially when using VBA, avoid merged cells.

I'm sorry, but I'm not even going to look at your file, the heading scares me off!