if cell = x then copy paste info in K1 or k2, etc..If cell = y, then copy info in D1,d2, e

Hi,

I would like to do the following:

Column D has 4 categories. When lets say, D1 is written "Matched". I would like the info in K1 to be copied in another sheet.

When Column D give me the categories "No Match" (Let's say D5 is a no match) I would like the info in G5 to be copied in another sheet.


Easy enough?...i cant do it ...*cry*

macro doesnt work...It doesnt do anything!!!! There is no change recorded

Book1.xlsmHi,

I would like to do the following:

Column D has 2 categories (match and not match). When lets say, D2 is written "Matched". I would like the info in K2 to be copied in result sheet at a specific place but only if the number is not zero. If there is a match and the number in K2 is 0. I would like to copy the number from G2 instead.

When Column D give me the categories "No Match" (Let's say D5 is a no match) I would like the info in G5 to be copied in result sheet.



And this, I would like to create a loop that will go trough a list. I put the file in attachBook1.xlsmment

sorry for the confusion..and thanks for the help

codding send me to error!!