Transpose whole excel file through vba

[ash81sen]

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

[Steffen Thomsen]

Hi,

Try this

Please Login or Register  to view this content.

[ash81sen]

Hi Steffen,

Thanks for the your reply.

But I will not be able to hardcode as the last cell is not always same.

Also I need to transpose the whole thing again from the same place as the original table.

Kindly help

Thanks in advance.

[Steffen Thomsen]

But I will not be able to hardcode as the last cell is not always same.

This can be done by doing this

[CODE]
Range("A3:C" & Range("C3").end(xlDown).Row).Copy
[CODE]

Also I need to transpose the whole thing again from the same place as the original table.

Im not sure what you mean here, is it not like you showed in the sample workbook?
If it isn't then please upload a new example, that describes the whole problem.

You do not have to write in the workbook... Just a sheet with before data and following sheets with wanted output.