Forum Discussion
Formula help
Dears, Kindly i need your assist regarding the attached file as it contains amerged cells and i need to copy it with the same apperance without merge. Thanks in advance
An alternative strategy that could be useful is to copy by formula but avoid all the formatting that makes the sheet look nice for a person but can be a nightmare when it comes to calculating with the data.
Blank columns could be removed and level 1 headings copied across so that there is a replica along with every level 2 header. Only when the calculation is complete would you have a need for pretty formatting).