Compare Columns
Hi,
I'm new to VBA. i manage to read through the column find duplicate.but i can't get what i want.Anyone can help?
My logic is this, read whole Column1, if Column1 row 5 & 6 cells is indentical, next will compare Column2 Row 5 & 6.If Column2 row 5 & 6 cells contain different value, Column1 row 5 & 6 will split out with _01 and _02. IF Column2 row 5 & 6 cells is indentical, Column1 row 5 & 6 remain the same. No split.
Last edited by waka; 10-27-2009 at 06:25 PM.
That doesn't explain
- why B1, C1, D1 change
- why B2B9 change
- why A5 changes
and so on.
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
Here, this may help to understand
Last edited by waka; 10-27-2009 at 06:22 PM.
Originally Posted by xld
Thanks for you response and i appreciate for everything..
why B1 change because just you look down the Column B u will see B1 & B9 is identical and as compare to C1 & C9 both of them are different value resulted B1 and B9 need to split. If C1 & C9 is holding the identical value, B1 and B9 don't have to split.
why B2B8 change because u compare to C2C8 both are different value resulted B2B8 have to change.
why C1 change because apply same theory, If you just look down at column C and you will see a few is identical value but this time round is compare Column D. Column D value is identical, column C will remain no change. if Column D value is different column C will change.
as for A5 change is my typo. actually is DH not DJ.
I try to make all rows 1 is to 1 condition.
Last edited by waka; 10-27-2009 at 06:32 PM.
Posting Permissions
Reply With Quote
