Naveed7991
New Member
- Joined
- Nov 28, 2017
- Messages
- 2
Hello,
I am naveed, this is the first time ever i am writing on a web portal for help. I hope this works out, below mentioned is my query.
1. Imagine below is the data that we have in Sheet 1
<style>table { }td { padding: 0px; color: black; font-size: 12pt; font-weight: 400; font-style: normal; text-decoration: none; font-family: Calibri,sans-serif; vertical-align: bottom; border: medium none; white-space: nowrap; }.xl65 { text-align: center; border: 0.5pt solid windowtext; }.xl66 { text-align: center; border: 0.5pt solid windowtext; background: yellow none repeat scroll 0% 0%; }</style>
<colgroup><col style="width:65pt" span="4" width="87"> </colgroup><tbody>
</tbody>
2. I would like to see the below view in Sheet 2 ( All the column headers)
<style>table { }td { padding: 0px; color: black; font-size: 12pt; font-weight: 400; font-style: normal; text-decoration: none; font-family: Calibri,sans-serif; vertical-align: bottom; border: medium none; white-space: nowrap; }.xl65 { text-align: center; border: 0.5pt solid windowtext; background: yellow none repeat scroll 0% 0%; }</style>
<colgroup><col style="width:65pt" width="87"> </colgroup><tbody>
</tbody>
3. Now if i swap any column in Sheet 2 as shown below.
<style>table { }td { padding: 0px; color: black; font-size: 12pt; font-weight: 400; font-style: normal; text-decoration: none; font-family: Calibri,sans-serif; vertical-align: bottom; border: medium none; white-space: nowrap; }.xl65 { text-align: center; border: 0.5pt solid windowtext; background: yellow none repeat scroll 0% 0%; }</style>
<colgroup><col style="width:65pt" width="87"> </colgroup><tbody>
</tbody>
4. The data in Sheet 1 should be swapped as shown below
<style>table { }td { padding: 0px; color: black; font-size: 12pt; font-weight: 400; font-style: normal; text-decoration: none; font-family: Calibri,sans-serif; vertical-align: bottom; border: medium none; white-space: nowrap; }.xl65 { text-align: center; border: 0.5pt solid windowtext; }.xl66 { text-align: center; border: 0.5pt solid windowtext; background: yellow none repeat scroll 0% 0%; }</style>
<colgroup><col style="width:65pt" span="4" width="87"> </colgroup><tbody>
</tbody>
I hope this explains well, and to let you know if am not a Macro guy, i just do basic excel stuff. If there is any explanation to this request it to be posted in detail so that i can do it from my end.
I am naveed, this is the first time ever i am writing on a web portal for help. I hope this works out, below mentioned is my query.
1. Imagine below is the data that we have in Sheet 1
<style>table { }td { padding: 0px; color: black; font-size: 12pt; font-weight: 400; font-style: normal; text-decoration: none; font-family: Calibri,sans-serif; vertical-align: bottom; border: medium none; white-space: nowrap; }.xl65 { text-align: center; border: 0.5pt solid windowtext; }.xl66 { text-align: center; border: 0.5pt solid windowtext; background: yellow none repeat scroll 0% 0%; }</style>
A | B | C | D |
1 | 2 | 3 | 4 |
8 | 7 | 6 | 5 |
9 | 0 | 11 | 32 |
<colgroup><col style="width:65pt" span="4" width="87"> </colgroup><tbody>
</tbody>
2. I would like to see the below view in Sheet 2 ( All the column headers)
<style>table { }td { padding: 0px; color: black; font-size: 12pt; font-weight: 400; font-style: normal; text-decoration: none; font-family: Calibri,sans-serif; vertical-align: bottom; border: medium none; white-space: nowrap; }.xl65 { text-align: center; border: 0.5pt solid windowtext; background: yellow none repeat scroll 0% 0%; }</style>
A |
B |
C |
D |
<colgroup><col style="width:65pt" width="87"> </colgroup><tbody>
</tbody>
3. Now if i swap any column in Sheet 2 as shown below.
<style>table { }td { padding: 0px; color: black; font-size: 12pt; font-weight: 400; font-style: normal; text-decoration: none; font-family: Calibri,sans-serif; vertical-align: bottom; border: medium none; white-space: nowrap; }.xl65 { text-align: center; border: 0.5pt solid windowtext; background: yellow none repeat scroll 0% 0%; }</style>
A |
D |
C |
B |
<colgroup><col style="width:65pt" width="87"> </colgroup><tbody>
</tbody>
4. The data in Sheet 1 should be swapped as shown below
<style>table { }td { padding: 0px; color: black; font-size: 12pt; font-weight: 400; font-style: normal; text-decoration: none; font-family: Calibri,sans-serif; vertical-align: bottom; border: medium none; white-space: nowrap; }.xl65 { text-align: center; border: 0.5pt solid windowtext; }.xl66 { text-align: center; border: 0.5pt solid windowtext; background: yellow none repeat scroll 0% 0%; }</style>
A | D | C | B |
1 | 4 | 3 | 2 |
8 | 5 | 6 | 7 |
9 | 32 | 11 | 0 |
<colgroup><col style="width:65pt" span="4" width="87"> </colgroup><tbody>
</tbody>
I hope this explains well, and to let you know if am not a Macro guy, i just do basic excel stuff. If there is any explanation to this request it to be posted in detail so that i can do it from my end.