Hi can anyone help,

I have created a dropdown list in excel using data validation which I am
then using via lookups to fill in a table below, but some of the column
headers are merged by two cells and others by four, is there any way to
create a macro by when a selection is made via the dropdown list it will
format the merged cells accordingly,

Thanks