simonmiller
New Member
- Joined
- Dec 31, 2010
- Messages
- 19
Hallo Everyone.
I hope someone can help me. I have a sent of data like this. (Sheet One)
Excel 2007
<colgroup><col style="width: 25pxpx"><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
And another sheet with this Data (Sheet 2)
Excel 2007
<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
You will notice the last column in Sheet one (New Product) and the First Colomb in (Sheet 2) is both New Product.
I need it to look like this.
Excel 2007
<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
Please keep in mine the above info is just a example. There might be places where the sheet might not find the code to match. A error will be ok.
I hope it makes sense.
Thank you
I hope someone can help me. I have a sent of data like this. (Sheet One)
Excel 2007
A | B | C | |
---|---|---|---|
1 | Unique ID | handle | New Code |
2 | 6101f5b9-9c82-11e3-a0f5-b8ca3a64f8f4 | NO01 | 040-5000 |
3 | 613b7cbf-9c82-11e3-a0f5-b8ca3a64f8f4 | NO02A | 040-5003 |
4 | 612a23b5-9c82-11e3-a0f5-b8ca3a64f8f4 | NO02 | 040-5002 |
5 | 6118c87c-9c82-11e3-a0f5-b8ca3a64f8f4 | NO01A | 040-5001 |
6 | 614c7b6d-9c82-11e3-a0f5-b8ca3a64f8f4 | NO03 | 040-5004 |
7 | 6180f876-9c82-11e3-a0f5-b8ca3a64f8f4 | NO07 | 040-5007 |
8 | 616f448a-9c82-11e3-a0f5-b8ca3a64f8f4 | NO05 | 040-5006 |
9 | 615dd1cf-9c82-11e3-a0f5-b8ca3a64f8f4 | NO04 | 040-5005 |
10 | 61b64337-9c82-11e3-a0f5-b8ca3a64f8f4 | NO09A | 040-5010 |
11 | 61a44f63-9c82-11e3-a0f5-b8ca3a64f8f4 | NO09 | 040-5009 |
12 | 6192933a-9c82-11e3-a0f5-b8ca3a64f8f4 | NO08 | 040-5008 |
13 | 61c7e53d-9c82-11e3-a0f5-b8ca3a64f8f4 | NO10 | 040-5011 |
14 | 61d938d3-9c82-11e3-a0f5-b8ca3a64f8f4 | NO11 | 040-5013 |
15 | 61ea442a-9c82-11e3-a0f5-b8ca3a64f8f4 | NO12 | 040-5014 |
<colgroup><col style="width: 25pxpx"><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
Sheet1
And another sheet with this Data (Sheet 2)
Excel 2007
A | B | C | D | E | F | G | H | I | |
---|---|---|---|---|---|---|---|---|---|
1 | New Code | Discrip | New Code | old Code | Cost Excl | Retail Incl | |||
2 | 040-5014 | NYLON MALE ADAPTOR 50MM | 040-5014 | NO.12 | 15.57 | 7.94 | 17.75 | 20.00 | |
3 | 040-5013 | NYLON CONNECTOR 50MM | 040-5013 | NO.11 | 13.31 | 6.79 | 15.18 | 15.00 | |
4 | 040-5011 | NYLON INSERT ELBOW 90 DEG 50MM | 040-5011 | NO.10 | 20.58 | 10.49 | 23.46 | 25.00 | |
5 | 040-5010 | NYLON COMBINATION ELBOW 45 DEG 50MM | 040-5010 | NO.09A | 21.81 | 11.12 | 24.86 | 25.00 | |
6 | 040-5009 | NYLON COMBINATION ELBOW 90 DEG 50MM | 040-5009 | NO.09 | 19.83 | 10.11 | 22.61 | 25.00 | |
7 | 040-5008 | NYLON REDUCING BUSH 50MM - 40MM | 040-5008 | NO.08 | 32.34 | 16.50 | 36.87 | 35.00 | |
8 | 040-5007 | NYLON REDUCING CONNECTER 50MM - 40MM | 040-5007 | NO.07 | 13.63 | 6.95 | 15.54 | 15.00 | |
9 | 040-5006 | NYLON INSERT T PIECE 40MM | 040-5006 | NO.05 | 23.90 | 12.19 | 27.24 | 25.00 | |
10 | 040-5005 | NYLON MALE ADAPTOR 40MM | 040-5005 | NO.04 | 12.02 | 6.13 | 13.71 | 15.00 | |
11 | 040-5004 | NYLON CONNECTOR 40MM | 040-5004 | NO.03 | 10.81 | 5.51 | 12.32 | 10.00 | |
12 | 040-5003 | NYLON INSERT ELBOW 45 DEG 40MM | 040-5003 | NO.02A | 17.97 | 9.16 | 20.48 | 20.00 | |
13 | 040-5002 | NYLON INSERT ELBOW 90 DEG 40MM | 040-5002 | NO.02 | 13.61 | 6.94 | 15.52 | 15.00 | |
14 | 040-5001 | NYLON COMBINATION ELBOW 45 DEG 40MM | 040-5001 | NO.01A | 15.44 | 7.88 | 17.60 | 20.00 | |
15 | 040-5000 | NYLON COMBINATION ELBOW 90 DEG 40MM | 040-5000 | NO.01 | 15.85 | 8.08 | 18.07 | 20.00 |
<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
Sheet2
You will notice the last column in Sheet one (New Product) and the First Colomb in (Sheet 2) is both New Product.
I need it to look like this.
Excel 2007
A | B | C | D | E | F | G | H | I | J | K | L | |
---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Unique ID | handle | New Code | New Code | Discrip | New Code | old Code | Cost Excl | Retail Incl | |||
2 | 61ea442a-9c82-11e3-a0f5-b8ca3a64f8f4 | NO12 | 040-5014 | 040-5014 | NYLON MALE ADAPTOR 50MM | 040-5014 | NO.12 | 15.57 | 7.94 | 17.75 | 20.00 | |
3 | 61d938d3-9c82-11e3-a0f5-b8ca3a64f8f4 | NO11 | 040-5013 | 040-5013 | NYLON CONNECTOR 50MM | 040-5013 | NO.11 | 13.31 | 6.79 | 15.18 | 15.00 | |
4 | 61c7e53d-9c82-11e3-a0f5-b8ca3a64f8f4 | NO10 | 040-5011 | 040-5011 | NYLON INSERT ELBOW 90 DEG 50MM | 040-5011 | NO.10 | 20.58 | 10.49 | 23.46 | 25.00 | |
5 | 61b64337-9c82-11e3-a0f5-b8ca3a64f8f4 | NO09A | 040-5010 | 040-5010 | NYLON COMBINATION ELBOW 45 DEG 50MM | 040-5010 | NO.09A | 21.81 | 11.12 | 24.86 | 25.00 | |
6 | 61a44f63-9c82-11e3-a0f5-b8ca3a64f8f4 | NO09 | 040-5009 | 040-5009 | NYLON COMBINATION ELBOW 90 DEG 50MM | 040-5009 | NO.09 | 19.83 | 10.11 | 22.61 | 25.00 | |
7 | 6192933a-9c82-11e3-a0f5-b8ca3a64f8f4 | NO08 | 040-5008 | 040-5008 | NYLON REDUCING BUSH 50MM - 40MM | 040-5008 | NO.08 | 32.34 | 16.50 | 36.87 | 35.00 | |
8 | 6180f876-9c82-11e3-a0f5-b8ca3a64f8f4 | NO07 | 040-5007 | 040-5007 | NYLON REDUCING CONNECTER 50MM - 40MM | 040-5007 | NO.07 | 13.63 | 6.95 | 15.54 | 15.00 | |
9 | 616f448a-9c82-11e3-a0f5-b8ca3a64f8f4 | NO05 | 040-5006 | 040-5006 | NYLON INSERT T PIECE 40MM | 040-5006 | NO.05 | 23.90 | 12.19 | 27.24 | 25.00 | |
10 | 615dd1cf-9c82-11e3-a0f5-b8ca3a64f8f4 | NO04 | 040-5005 | 040-5005 | NYLON MALE ADAPTOR 40MM | 040-5005 | NO.04 | 12.02 | 6.13 | 13.71 | 15.00 | |
11 | 614c7b6d-9c82-11e3-a0f5-b8ca3a64f8f4 | NO03 | 040-5004 | 040-5004 | NYLON CONNECTOR 40MM | 040-5004 | NO.03 | 10.81 | 5.51 | 12.32 | 10.00 | |
12 | 613b7cbf-9c82-11e3-a0f5-b8ca3a64f8f4 | NO02A | 040-5003 | 040-5003 | NYLON INSERT ELBOW 45 DEG 40MM | 040-5003 | NO.02A | 17.97 | 9.16 | 20.48 | 20.00 | |
13 | 612a23b5-9c82-11e3-a0f5-b8ca3a64f8f4 | NO02 | 040-5002 | 040-5002 | NYLON INSERT ELBOW 90 DEG 40MM | 040-5002 | NO.02 | 13.61 | 6.94 | 15.52 | 15.00 | |
14 | 6118c87c-9c82-11e3-a0f5-b8ca3a64f8f4 | NO01A | 040-5001 | 040-5001 | NYLON COMBINATION ELBOW 45 DEG 40MM | 040-5001 | NO.01A | 15.44 | 7.88 | 17.60 | 20.00 | |
15 | 6101f5b9-9c82-11e3-a0f5-b8ca3a64f8f4 | NO01 | 040-5000 | 040-5000 | NYLON COMBINATION ELBOW 90 DEG 40MM | 040-5000 | NO.01 | 15.85 | 8.08 | 18.07 | 20.00 |
<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
vend-products-31282
So basically getting the data from Sheet 2 and Copying in next to the data from sheet one. HOWEVER and this is what the issue is. In the last Screenshot above - The tow (New Products) column (C and D ) need to be matched up to the same code. And the data next to it has to remain inline with the code when it its sorting and lineing it up. Please keep in mine the above info is just a example. There might be places where the sheet might not find the code to match. A error will be ok.
I hope it makes sense.
Thank you