Delete Row when cell contains another cell text

[Kell2Jam]

Hi, very new to this.

I need help with finding data from one sheet to finding data in another sheet and deleting that row.
I have had a lot of trouble with this and cant seem to crack it.
Can anyone help a formula?

 

[Kell2Jam]

I seem to have gotten Run-time error '5'
Invalid Procedure call or argument after it ran through that code about 10 times

 

[Kell2Jam]

Hey Mate,

I have received Run-time error '5'
Invalid Procedure call or argument.

after it ran through the code about 10 times

 

[MARK858]

No idea why you have suddenly got that error after 10 runs. What has changed in the data?

 

[Kell2Jam]

Nothing has changed at all

 

[MARK858]

Are you sure that every cell value in Last report column A has a match in Open PO's Report column A?

 

[Kell2Jam]

Im Assuming that it would not copy if the data was not found?

 

[MARK858]

It will error if there is no match, you haven't mentioned having no matches in your data (and it would have happened the first time you ran the code if the data was the same so the data has changed if you ran the code fully before).

 

[Kell2Jam]

Sorry about that, did not mean to cause confusion or miss lead

 

[MARK858]

So can you confirm
A) that you do have the possibility of not having a match?
B) if the answer to the above is true what you want to happen with the unmatched data?
C) did you run the code fully at the start?

 

[Kell2Jam]

When it runs there is the possabiltiy that there will not be a match

if no match is found than i dont need it to copy

I did run it fully but the data must have updated from the file it extracted from, there are other people that have access to this workbook as it is on a p drive system.