Copy text in colum each time it is a new text
Can someone help with a macro?
In column C I have the same text in a various number of rows, but always
after each other.
Each time the text in column C changes I want the macro to do this:
To a new sheet, caled "test" copy the number from "C"one time and also copy
the belonging contents of column A+B
I want the numbers under each other in sheet test
Example:
A B C
20160311 3635127 X8YELLOW
20160311 3635127 X8YELLOW
20160311 3635127 X8YELLOW
20160310 6355014 G9BLACK
20160310 6355014 G9BLACK
20160310 6355014 G9BLACK
The sheet test should look like this:
20160311 3635127 X8YELLOW
20160310 6355014 G9BLACK
I also want to define the range to be looked through.
Best regards,
Kaj Pedersen
|