I have an excel file that is exported from somewhere.

It has rows and columns formated(colored and bolded) based on various criteria.

Now I have to write a macro that will just transport the whole excel file with all the formating.

I have attached the format of the input and output in the file "Sample_Transpose.xls"Sample_Transpose.xls

Kindly help


Thanks in advance