rafi_07max
01-23-2011, 07:54 AM
I have some contents in cell B1 and cell C1.
For e.g. the content in cell B1 is,
DAT8, G8, D4, A8, NQ8, "C7", ground, G7, 5, P14
And the content in cell C1 is
DAT8, D4, ground, C8, "C7", E7, 5, F4, F3, E8
If we compare the two contents we can see that some values can be found in both cells.
For e.g. DAT8, D4, ground, “C7” and 5
So what I want to do is to remove all these repeated contents from cell C1.
After running the macro successfully the content in cell C1 should be
C8, E7, F4, F3, E8
And the content in cell B1 should remains as how it was initially,
DAT8, G8, D4, A8, NQ8, "C7", ground, G7, 5, P14
For e.g. the content in cell B1 is,
DAT8, G8, D4, A8, NQ8, "C7", ground, G7, 5, P14
And the content in cell C1 is
DAT8, D4, ground, C8, "C7", E7, 5, F4, F3, E8
If we compare the two contents we can see that some values can be found in both cells.
For e.g. DAT8, D4, ground, “C7” and 5
So what I want to do is to remove all these repeated contents from cell C1.
After running the macro successfully the content in cell C1 should be
C8, E7, F4, F3, E8
And the content in cell B1 should remains as how it was initially,
DAT8, G8, D4, A8, NQ8, "C7", ground, G7, 5, P14