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!!!!
|