Merging of Cells

[vidya_lakshman01]

Hi,
I am a newbie in excel programming n need a solution for one of the problem.

Please refer the attachment and help me out with your solutions.

I need to merger the cells from Column F-J based on the no. of validations that a particular filetype(Column C) has.
Eg: doc has validation1-validation 5.So merger them.
Similarly xls has validation1-Validation3.So merge them
and so on.

Kindly help me in figuring out how this can be done at the earliest.

regards
Vidya

[johnjohns]

I found not attachment!

rgds

johnjohns

[davesexcel]

Seriously? you attached a word doc for an excel question?