Deleting row in another sheet depending on the value of a cell in the first sheet

[Martha Mary]

Hi
I have some VBA code which works fine to delete all rows in Sheet2 if the corresponding ID exists in Sheet1:
Sub CheckA()
Dim LR As Long, i As Long
With Sheets("Sheet1")
LR = .Range("A" & Rows.Count).End(xlUp).Row
For i = LR To 1 Step -1
If IsError(Application.Match(.Range("A" & i).Value, Sheets("Sheet2").Columns("A"), 0)) Then Rows(i).Delete
Next i
End With
End Sub

However I only want to delete the corresponding rows in Sheet2 if the contents of column M in Sheet1= "No" - can anyone advise how I need to amend this code to do this?

Appreciate any advice!

 

[Martha Mary]

If there are no leading/trailing spaces in the data, then I'm not sure why it isn't working for you.
Can you provide your workbook?

i could provide you with a dummy copy?

 

[Fluff]

That's fine as long as it still shows the problem.
You will need to upload it to a share site such as OneDrive, GoogleDrive, DropBox. Then mark for sharing & post the link you are given here.

 

[Martha Mary]

If there are no leading/trailing spaces in the data, then I'm not sure why it isn't working for you.
Can you provide your workbook?

Sorry just noticed your response

 

[Fluff]

You can't, see post#12

 

[Martha Mary]

That's fine as long as it still shows the problem.
You will need to upload it to a share site such as OneDrive, GoogleDrive, DropBox. Then mark for sharing & post the link you are given here.

Sorry I dont think we have permissions to use those functions

 

[Fluff]

Ok.
Did you copy/paste the code I supplied, or retype it?

 

[Martha Mary]

You can't, see post#12

Ok.
Did you copy/paste the code I supplied, or retype it?

i pasted it

 

[Martha Mary]

i pasted it

I was going to try to do this via Google Drive on my phone as it is only dummy data, but I dont have the correct version of Excel to support the macros.......but a thousand thanks for trying to help!

 

[Fluff]

Not sure what your saying, all versions of Excel support macros (except the browser version)

 

[Martha Mary]

Not sure what your saying, all versions of Excel support macros (except the browser version)

No what I mean is my the version isnt supported on my phone. I set up a formula there just to double check for training spaces and there are none. Not sure why the macro isnt working - but thank you anyway