Prevent overwriting when copying back to other sheet

Hi,
I've been searching a lot, but cannot find the right answer. I dont know much about VBA and programming so I hope you can help.
I have two excel sheets, one called "Column lot etc" and one "Discarded". I'm trying to make a database in which whenever a column is discarded (Yes/No value) it goes to the discarded sheet. So far so good, that works fine without overwriting. Then I kind of superimpose that Sub to whenever someone made a mistake and wants to put it back all they have to do is put No into the cell in to the discarded sheet again. That works as well, but somehow this time it overwrites the same row over and over again, which already contains data. I cannot seem to find a good code for that that is fitting with the rest of my code (and yes I dont understand coding that much either, just snagged this off of internet and adapted it so that it hopefully works).
In column lot etc sheet I have data from column B tm I that needs to be copied into "discarded" column A tm G.
This is the working properly code for transferring the column lot etc to discarded

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Then this is the code for moving it back (which overwrites the same row over and over again)

Please Login or Register  to view this content.

Oh and i'm using office 365
Hope you can help!

Welcome to the forum.

Please review the forum rules regarding code tags. Thanks.

You think you can explain in a concise (kort maar krachtig) manner what you want to accomplish.
Now we have to go through your code that does partially do what you want supposedly and not do what you want and everybody, most people anyway, do solve problems differently.
BTW, the "On Error Resume Next" should be followed by "On Error GoTo 0".

Does this transfer the "Yes" Rows?
Not tested! Try on a Copy of your original.

Please Login or Register  to view this content.

It is assumed that both sheets have a header row (as they always should).
Change references if and wher required.
If your intention is to move cells from Column B to Column I in the Row where Column I has "Yes" in it's cell and delete this same range after, this should do that
The pasting of these cells will be in the first empty cell in Column A in the 2nd sheet.

Please Login or Register  to view this content.

If your intention is to move cells from Column A to Column H in the Row where Column H has "No" in it's cell and delete this same range after, this should do that
The pasting of these cells will be in the first empty cell in Column A in the 1st sheet.

Please Login or Register  to view this content.

If we had known that it was tables you're dealing with, things would have been different.
Attach a representative workbook to avoid confusion.
It explains at the top in the top yellow banner how to do this.

Originally Posted by jolivanes

If we had known that it was tables you're dealing with, things would have been different.
Attach a representative workbook to avoid confusion.
It explains at the top in the top yellow banner how to do this.

I'm sorry, I realized it after it copied below the table that the cells were not 'empty'. I cannot share the excel, it has sensitive information from the company I work for. I'm going on holidays after today, so I'll just let them copy it back themselves in this case. I really really appreciate all the time you put in here, I learned a lot from it (although it might not seem like it to you). I will come back to it after my holidays in a few weeks if that is ok with you, then I'll prepare a dummy excel without the sensitive info and we can look at it again. Would like to see how this needs to be resolved!
Thanks again!