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!

 

[Fluff]

You're welcome.

 

[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.

Hey there i have been able to save this to One Drive - what link do I need to copy this to? I havent used this before

 

[Fluff]

If you right click the file & select Share, a new window will open & click the Copy button, then another window will open click copy on that & then paste the link to the thread.

 

[Martha Mary]

If you right click the file & select Share, a new window will open & click the Copy button, then another window will open click copy on that & then paste the link to the thread.

Test - Copy (2).xlsx

 

[Fluff]

I get an error with that, it says the fileformat doesn't match the extension.
The file should really be either an xlsm or xlsb file

 

[Martha Mary]

I get an error with that, it says the fileformat doesn't match the extension.
The file should really be either an xlsm or xlsb file

It is an xlsm file but i am getting a message on my One Drive to say this version of Excel cant run VBA macros so that must be where the problem is

 

[Fluff]

You should still be able to copy macro enabled files to onedrive.

 

[Martha Mary]

You should still be able to copy macro enabled files to onedrive.

i have it copied ok and i can see it but it doesnt send - I can send as an attachment but not as a link. So sorry to have wasted your time