View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
[email protected] koperstexdq_dont_use@gmail.com is offline
external usenet poster
 
Posts: 28
Default 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