Dazzawm
Well-known Member
- Joined
- Jan 24, 2011
- Messages
- 3,748
- Office Version
- 365
- Platform
- Windows
Hi. I need a code that will tell me if there are any descriptions that are different to a particular number. In the sample below you can see there is some data in AD. When the a number is found on sheet 1 and the description is different in AE anywhere else on the sheet then I need these copied to sheet 2 like the second example. Thanks.
Excel 2010
<tbody>
</tbody>
As you can see rows 5, 6 & 7 all match so they don't need copying, the others do because there are different descriptions to the same part number.
Excel 2010
<tbody>
</tbody>
I must add they will not be grouped together as above, the first number may be row 2 then not appear again until row 100,002 for example.
Excel 2010
AD | AE | |
---|---|---|
1 | Part | Description |
2 | TX1234 | Example |
3 | TX1234 | Example |
4 | TX1234 | Example 1 |
5 | TX1237 | Example 2 |
6 | TX1237 | Example 2 |
7 | TX1237 | Example 2 |
8 | TX1240 | Example 3 |
9 | TX1240 | Example 4 |
<tbody>
</tbody>
Sheet1
As you can see rows 5, 6 & 7 all match so they don't need copying, the others do because there are different descriptions to the same part number.
Excel 2010
A | B | |
---|---|---|
1 | Part | Description |
2 | TX1234 | Example |
3 | TX1234 | Example |
4 | TX1234 | Example 1 |
5 | TX1240 | Example 3 |
6 | TX1240 | Example 4 |
<tbody>
</tbody>
Sheet2
I must add they will not be grouped together as above, the first number may be row 2 then not appear again until row 100,002 for example.
Last edited: