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.
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.