An interesting problem
 

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

An interesting problem
 

On Oct 12, 3:31 pm, mike wrote:
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!!!!

An interesting problem
 

Hi Harshad,

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

Mike

" wrote:

On Oct 12, 3:31 pm, mike wrote:
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!!!!

An interesting problem
 

I found it.
Thanks

"mike" wrote:

Hi Harshad,

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

Mike

" wrote:

On Oct 12, 3:31 pm, mike wrote:
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!!!!