elsuji
12-18-2019, 09:45 AM
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
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