An interesting problem

[mike]

Hi All,

I have an interesting problem...
I have a worksheet which is filled with data, criteria is isted in column A.
My supervisor has now decided this layout isn't what she wants.
So, rather than having to re-enter all the data, is there a method/macro
that will copy all the data to a new sheet where the criteria is in row 1
instead.

Thanks in advance

mike


example:

current -

criteria - Co. X - Co. Y - Co. Z
1 - info - info - info
2 - info - info - info
3 - info - info - info

required -

criteria 1 - 2 - 3
Co. X - info - info - info
Co. Y - info - info - info
Co. Z - info - info - info

 

[harshad.madhu]

Hi All,

I have an interesting problem...
I have a worksheet which is filled with data, criteria is isted in column A.
My supervisor has now decided this layout isn't what she wants.
So, rather than having to re-enter all the data, is there a method/macro
that will copy all the data to a new sheet where the criteria is in row 1
instead.

Thanks in advance

mike

example:

current -

criteria - Co. X - Co. Y - Co. Z
1 - info - info - info
2 - info - info - info
3 - info - info - info

required -

criteria 1 - 2 - 3
Co. X - info - info - info
Co. Y - info - info - info
Co. Z - info - info - info

--- Simple... Copy the source.... Paste Special (To new sheet as u
require) --> Select Transpose..... U r done!!!!

 

[mike]

Hi Harshad,

Thanks for your reply.
Do you mean to write this into a macro?

Mike

 

[mike]

I found it.
Thanks

Hi Harshad,

Thanks for your reply.
Do you mean to write this into a macro?

Mike