VBA code to copy entire row IF a specific word is in a SPECIFIC column

ΔΙΑΧΕΙΡΙΣΗ_ΑΥΤΟΨΙΩΝ_&_ΚΑΘΑΡΙΣΜΩΝ_ΜΑΣΤΟΡΗΣ.xlsx

Here it is

Thanks. Will test it tomorrow as i am on a mini sabbatical.

Hello again

[USER="31712"]Carim[/USER] well, it actually works but..When i put "OXI" in Sheet1 K4, a number is created in L4 cell. The same happens with Sheet1 K5 (it creates a number in L5 cell). Dunno why. But it works.

On the other hand when i delete the "OXI" from Sheet1 K4 the line inserted on Sheet 2 is not deleted. So, these are my 2 issues. Other than that it seems to work. Can y check those 2 issues?

1. Correct.
2. When i delete OXI in Sheet1 cell K4, the range A;H which had been copied earlier to sheet2 row x IS NOT deleted (and i want to automatically been deleted). Can you add a code for that?

[USER="31712"]Carim[/USER] hello again friend

It partially works. Make this test:

Put OXI in K4, K5 and K6 in that order. Row 19, 20 is created in sheet2. No line 21 though. I guess there is an error there

Oups: There is a whole line that is missing from your V2 file. I guess you delete it by accident. That made the code not work as excpected

This is the original file to check it again

ORIGINAL.xlsx

Well wait. Let me explain my self.

While your code works, it does it - partially.

Just make a test to see what i am talking about:

- Insert an OXI in Sheet's 1 K8 cell (in original.xlsx file which is my original file). It will insert this row as a line 19 in sheet2.
- Now import an OXI in Sheet's 1 K4 cell. It will insert this row as a line 20 in sheet2. Until now the code works as expected.

Now delete OXI in K8 cell. While the data of line 19 in sheet2 is gone, the data in line 20 now becomes the data in row 19. That is wrong. The row 19 should remain - but with no data in it.

Yes it is a unique number. But why do y ask? Will this help you with your code?

Thanks i will wait.

Thanks man! That works as expected!!

I know i have become a burden but there is an other issue that i may need your help (if y can help me with this - i would be very grateful :)).

As you can see in sheet1 in J column there are some dates inserted. Those dates are connected with A1 cell (which has the today date. That date in A1 is changing every day). Among with date numbers there are some N/A which is the abbreviation of Not Available data. There are 2 colors also. Red and green (and no color for N/A)

Lets say that the "test" cell is J6 (18/10/2019, which means October 18 of 2019).

I have created this condition: When J6 cell value=$A$1 (that condition applies to the whole J column of course), the specific cell turns into "RED". For cell value>$A$1 the cell becomes green.

Now what i also want is that:

For the red cells, i want this color to remain red UNTIL a "NAI" or "OXI" value is inserted into column K. Only until then the color will change to green (dont forget that with OXI the row is also been copied into sheet2 too of course). In other words if there is a NAI OR NO in K column, then the color of the adjacent cell will turn GREEN

I know that i am a pain in the ass, but is that possible?

Oh..That seems to work ! Great thanks !:)