asyamonique
Well-known Member
- Joined
- Jan 29, 2008
- Messages
- 1,280
- Office Version
- 2013
- Platform
- Windows
Hello,
Please help me with given sample tables below.
First table shows the original datas...
Second table is the results what I wanted to get by clicking the button all datas will randomly changed with below conditions.
1. Column A and Column B will be related datas.(If A1 goes to another row, B1 will follow that..)
2. Column C and Column D will not be related datas they will be shuffled in same columns!
3. Column E will be related with column A datas.
Many Thanks
<colgroup><col><col span="2"><col><col></colgroup><tbody>
</tbody>
<colgroup><col><col span="2"><col><col></colgroup><tbody>
</tbody>
Please help me with given sample tables below.
First table shows the original datas...
Second table is the results what I wanted to get by clicking the button all datas will randomly changed with below conditions.
1. Column A and Column B will be related datas.(If A1 goes to another row, B1 will follow that..)
2. Column C and Column D will not be related datas they will be shuffled in same columns!
3. Column E will be related with column A datas.
Many Thanks
COLUMN-A- | COLUMN-B- | COLUMN-C- | COLUMN-D- | COLUMN-E- |
name1 | abc1 | def1 | ghi1 | 10,000 |
name2 | abc2 | def2 | ghi2 | 20,000 |
name3 | abc3 | def3 | ghi3 | 30,000 |
name4 | abc4 | def4 | ghi4 | 40,000 |
name5 | abc5 | def5 | ghi5 | 50,000 |
name6 | abc6 | def6 | ghi6 | 60,000 |
name7 | abc7 | def7 | ghi7 | 70,000 |
name8 | abc8 | def8 | ghi8 | 80,000 |
name9 | abc9 | def9 | ghi9 | 90,000 |
name10 | abc10 | def10 | ghi10 | 100,000 |
name11 | abc11 | def11 | ghi11 | 110,000 |
name12 | abc12 | def12 | ghi12 | 120,000 |
name13 | abc13 | def13 | ghi13 | 130,000 |
name14 | abc14 | def14 | ghi14 | 140,000 |
name15 | abc15 | def15 | ghi15 | 150,000 |
name16 | abc16 | def16 | ghi16 | 160,000 |
name17 | abc17 | def17 | ghi17 | 170,000 |
name18 | abc18 | def18 | ghi18 | 180,000 |
name19 | abc19 | def19 | ghi19 | 190,000 |
name20 | abc20 | def20 | ghi20 | 200,000 |
<colgroup><col><col span="2"><col><col></colgroup><tbody>
</tbody>
COLUMN-A- | COLUMN-B- | COLUMN-C- | COLUMN-D- | COLUMN-E- |
name10 | abc10 | def13 | ghi11 | 100,000 |
name12 | abc12 | def8 | ghi13 | 120,000 |
name19 | abc19 | def2 | ghi1 | 190,000 |
name9 | abc9 | def15 | ghi19 | 90,000 |
name17 | abc17 | def4 | ghi10 | 170,000 |
name1 | abc1 | def17 | ghi5 | 10,000 |
name11 | abc11 | def14 | ghi2 | 110,000 |
name7 | abc7 | def18 | ghi9 | 70,000 |
name8 | abc8 | def10 | ghi6 | 80,000 |
name15 | abc15 | def12 | ghi15 | 150,000 |
name4 | abc4 | def7 | ghi7 | 40,000 |
name18 | abc18 | def16 | ghi14 | 180,000 |
name5 | abc5 | def6 | ghi12 | 50,000 |
name3 | abc3 | def9 | ghi17 | 30,000 |
name14 | abc14 | def11 | ghi4 | 140,000 |
name6 | abc6 | def3 | ghi3 | 60,000 |
name20 | abc20 | def19 | ghi16 | 200,000 |
name2 | abc2 | def20 | ghi20 | 20,000 |
name16 | abc16 | def1 | ghi8 | 160,000 |
name13 | abc13 | def5 | ghi18 | 130,000 |
<colgroup><col><col span="2"><col><col></colgroup><tbody>
</tbody>