Fill out already known columns

[osterwma]

Hi,

I copy every day new rows with errors into an excel spreadsheet from Column D to M. In relation to theses inputs I've to fill out the cellars from O to K.
Because there are every day also equal errors entering, I wanna code a macro which is able to check, if an error which is written in D to M already exist and if yes, then the macro should fill out the cellars from O to K with the information I wrote already for existing errors.

Example:
D E F G H I J K L M ..... O P Q R S T U
1 Z Z Z Z Z Z Z Z Z Z .. E E E E E E E <--- Already tracked errors
2 Z Z A Z Z Z Z A Z Z .. F F F F F F F <--- Already tracked errors

3 Z Z A Z Z Z Z A Z Z <--- New entry from today. Row 3 is equal to 1. So the macro should copy the entries from O1 to U1.
4 Z W F H J E S T W T <--- New entry from today. Completely new error. I've to fill the cellars from O3 to U3 by myself

I hope you can help me.

Thanks a lot in advance.

Greetings
Marv

[pjwhitfield]

Put the following into the relevant worksheets Module

EDIT: Just realised that didnt do exactly what you wanted, give me 5mins

[pjwhitfield]

On reflection I dont understand the requirement? You say that the data in columns D to M must match and then say in your example that 3 matches 1 however they dont! I assume thats a type and should have said 2 not 1 however even then they dont match as column D shows consecutive numbers therefore no column D's match?