PDA

View Full Version : Compare Columns



waka
10-27-2009, 07:12 AM
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? :dunno :banghead:

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.

Bob Phillips
10-27-2009, 08:06 AM
That doesn't explain

- why B1, C1, D1 change

- why B2B9 change

- why A5 changes

and so on.

waka
10-27-2009, 08:23 AM
Here, this may help to understand

waka
10-27-2009, 09:02 AM
That doesn't explain

- why B1, C1, D1 change

- why B2B9 change

- why A5 changes

and so on.
:help :help
Thanks for you response and i appreciate for everything..:bow:

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.