| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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!!!! |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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!!!! |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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!!!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Interesting problem! | Excel Programming | |||
| Interesting problem | Excel Programming | |||
| Interesting problem | Excel Programming | |||
| Most Interesting Problem I Had Ever Got. | Excel Programming | |||
Linear Mode
