Hi All,
I have Base record and Based on that I have n number of record with different name. Every record have common format but they create with some error how to identify that in vb:). How to compare that?
Sheet1:BASE
[TABLE="class: grid, width: 500"]
NAME
[/td]ID
[/td]VALUES
[/td]ICV1
[/td]APPLE
[/td]250 FROM GARDEN
[/td]ICV1
[/td]BANANA
[/td]NOT AVAILABLE
[/td]ICV1
[/td]ORANGE
[/td]$25 HAVE IN STOCK
[/td]
[/TABLE]
Sheet2:RECORDS
[TABLE="class: grid, width: 500"]
NAME
[/td]ID
[/td]VALUES
[/td]IBB1
[/td]APPLE
[/td]250 FROM GAR
[/td]IBB1
[/td]BANANA
[/td]AVAILABLE
[/td]IBB1
[/td]ORANGE
[/td]$25 NOT IN STOCK
[/td]IBB2
[/td]APPLE
[/td]250 FROM GARDEN
[/td]IBB2
[/td]BANANA
[/td]NOT AVAILABLE
[/td]IBB2
[/td]ORANGE
[/td]$25 HAVE IN STOCK
[/td]
[/TABLE]
I want result like,
SHEET3:RESULT
[TABLE="class: grid, width: 500, align: left"]
NAME
[/td]ID
[/td]DIFFERENCE
[/td]IBB1
[/td]APPLE
[/td]DEN
[/td]IBB1
[/td]BANANA
[/td]NOT
[/td]IBB1
[/td]ORANGE
[/td]NOT
[/td]
[/TABLE]
Can Macro will display only differences in the each name??:roll:
Regards,
Deva